bethconner
asked on
Adding up total hours worked
How can I correctly type in total hours worked so that I can have excel add them up correctly. I am typing in the hours worked and need in hours and minutes what they equal for each person separately.
total-hours-worked.xls
total-hours-worked.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In the example file provided, if you total up more than 24 hours it will start at 00:00 again. To get round this you need to apply a custom time format of [hh]:mm to the cells.
This was a time sheet for a single person that tallied daily hours then formatted to to decimal format for the week 1, 2 and biweekly totals fields.
feel free to reuse whatever you like
timesheet-example.xls
feel free to reuse whatever you like
timesheet-example.xls
ASKER
thank you, I knew it was something simple just was using h:mm instead of [h]:mm.
Thats in J5 you can use this formula...
=SUM(C5:I5)
Saurabh...
total-hours-worked-1-.xls