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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Hours & Minutes
Everything looks correct. What is your formula returning? Is it returning a
zero, or just some number that doesn't agree with what you think it should be? Possible problems: Are your formulas, for some reason, returning a text value thus causing SUM to = 0? What are the floating 5's in your example for? -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Tina" wrote: 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 |
Reply |
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 |