SUM doesn't work with Hours - It always returns 00.00

[robleyd]

The SUM function doesn't work with Hours - It always returns 00.00:

BugSUMWithHoursReturn0.png (13.98 KiB) Viewed 173 times

[F3K Total]

This is no BUG,
seems as if you use text instead of numbers.

SUM_TIME.PNG (7.49 KiB) Viewed 166 times

[RoryOF]

Time_sum.png (17.01 KiB) Viewed 165 times

please upload your sample file so we can see what you are doing wrong.

[robleyd]

Welcome to the forum.

This is not a bug - you need to format the cells with the times as time - HH:MM - and the cell in which you have the SUM to display hours greater than 24. Assuming you just want to display hours and minutes separated by a colon, use the format

Code: Select all   Expand viewCollapse view

[HH]:MM

in the cell with the total.

Note that posting an image in this case is not helpful; it shows what you see but gives no idea of how your spreadsheet is set up; thus we can't easily determine the problem without some guessing.

[RusselB]

The fact that the times you're trying to sum are left justified supports the presumption that the times are being interpreted as text, rather than numbers, which is what time is.