View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GAIDEN GAIDEN is offline
external usenet poster
 
Posts: 30
Default Adding up time values

work hours
04:31:26
01:14:19
01:57:24
02:27:32
03:01:01
02:42:15
02:34:16
02:11:15
02:17:57
00:24:35
02:03:44
01:10:22
03:23:12
10:09:12

I'm trying to add these work hours together and all i keep getting is
0:00:00. I've also tried formatting the work times (Example: 04:31:26 to
4.52 hours) without luck.