Adding hours and minutes

Hi all

I am new to the forum TODAY and I am at the mercy of you all!!!

I have a spreadsheet with start times, break times and finish times i.e. a timesheet. The last column is a sum calculating the net hours per day. No problem. What I can't remember is how to total these hours. When I do a normal sum formula it looks as though it takes the result of the daily hours as a fraction. All the cells have the same format i.e. time

Cheers

SUM as normal but use Custom Format [h]:mm

Perfect. Thank you. Do you know how to change it into decimal format as well?

Try Number format and multiply (*24)

Thank you.

You are welcome.
Coudl you leave feedback(please on the star under my avatar)