View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tina tina is offline
external usenet poster
 
Posts: 139
Default Adding Hours & Minutes

I am adding a large column of hours and need a total for the end of the
month.

0:00
0:00 5
0:00
0:00
0:00
0:00
0:00
0:00 5
0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
00:00
I have formulas in the cells above to calculate the number of hours when an
employee enters their time.

I can't get it to give me a correct value of the hours and minutes. This is
what my formula looks like: =SUM(E12:E37)

The cell is formatted to this: [hh]:mm