View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
it''''''''sh hardy it''''''''sh hardy is offline
external usenet poster
 
Posts: 18
Default Completing Formula For Hours Worked

Hello! -
I have an excel sheet that is totalling for hours worked, but if someone
works over 24 hours, the total starts over from 0 hour then again up to 24.
How do I format this cell to properly equate what the total hours worked is?

1:35
10:10
0:17
0:52
2:18
5:23
3:36
3:14
0:21
1:57




Total 5:43