Summation of Time Values

[rockchalk33]

00:00:11 + 00:00:25 = 00:00:36 or 0.01 hours

I cannot seem to get the =SUM() function to work with the HH:MM:SS time values.

Thanks for any help!

Devin

 

[Brian from Maui]

00:00:11 + 00:00:25 = 00:00:36 or 0.01 hours

I cannot seem to get the =SUM() function to work with the HH:MM:SS time values.

Thanks for any help!

Devin

What seems to be the problem?

36 seconds is .01 in decimal numbers

 

[Aladin Akyurek]

A1: 00:01:11
B1: 00:00:25

=SUM(A1:B1)

Custom format the formula cell as [hh]:mm:ss.

Note A1:B1 must be true time values, i.e. numbers.

 

[Tetra201]

00:00:11 + 00:00:25 = 00:00:36 or 0.01 hours

I cannot seem to get the =SUM() function to work with the HH:MM:SS time values.

Looks like your 00:00:11 and 00:00:25 are text strings, not numbers; SUM ignores them.
Try the following:

==(--A1+--B1)*24