Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding up hours and minutes | Excel Discussion (Misc queries) | |||
ADDING HOURS AND MINUTES | Excel Discussion (Misc queries) | |||
Adding minutes to hours/minutes | Excel Discussion (Misc queries) | |||
Adding hours and minutes | Excel Worksheet Functions | |||
adding hours and minutes | New Users to Excel |