View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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