Excel help please

[LegoAcupuncture]

I'm trying to do a time sheet, so far so good. I need to total the amount of hours at the bottom, but unable to get the correct formula. Any ideas please?

TIA

you could use Autosum. click on box where you want your total figure underneath your entries that need calculating. then go up top to right and find Autosum. just click on it and the calculation will be done.

Try entering your hours as HH:MM:SS, or HH:MM and see if that works.

I think you need to do both of the above.

Make sure the cells that hold the hours worked/total hours are set to time formula as Yourcall says. Then just use the autosum for the total hours, as Peedoff says.

You'll need to format cells to the hh:mm format. If you use sum on this though it'll count each 24 hours as a day. So if you require the result in total hours you will need to transfer your result into and absolute (abs) result then transfer it back into [h]:mm format.

There is also a way to count negative hours but it all starts getting complicated...

The hive mind in action.

Thanks everyone. Fiddled around with the time bit, changed it to [H]:00:00 and it worked.

I used to be a whizz with Excel, used to do timesheets, spreadsheets, collations etc now can barely do a formula these days.