Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Figure out the hours worked for the week
Could you help me if i need to Figure out the hours worked for the week
Example: Start time Finish time Difference 10:05:00 18:40:00 8:35:00 20:00:00 04:05:00 8:05:00 15:20:00 00:45:00 9:25:00 Total: ?? When i do autosum Total is 02:05:00 Thank you |
#2
|
|||
|
|||
Try formatting the cell as:
[h]:mm:ss or [hh]:mm:ss Svetlana wrote: Could you help me if i need to Figure out the hours worked for the week Example: Start time Finish time Difference 10:05:00 18:40:00 8:35:00 20:00:00 04:05:00 8:05:00 15:20:00 00:45:00 9:25:00 Total: ?? When i do autosum Total is 02:05:00 Thank you -- Dave Peterson |
#3
|
|||
|
|||
Set the format of the totals cell to [hh]:mm to cater for more than 24
hours. -- HTH RP (remove nothere from the email address if mailing direct) "Svetlana" wrote in message ... Could you help me if i need to Figure out the hours worked for the week Example: Start time Finish time Difference 10:05:00 18:40:00 8:35:00 20:00:00 04:05:00 8:05:00 15:20:00 00:45:00 9:25:00 Total: ?? When i do autosum Total is 02:05:00 Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting a total of hours & mins worked per week | New Users to Excel | |||
Excel needs hh:mm where hh>24 for hours worked per week | Excel Worksheet Functions | |||
How can I make a timesheet to figure my hours and payrate? | Excel Worksheet Functions | |||
calculate hours just can't figure it out | Excel Worksheet Functions | |||
calculate average hours worked | Excel Worksheet Functions |