How to sum and substract hours, minutes and seconds

[Guest]

Hello,
I'm searching for a function that count hours, minutes and seconds. When I
use SUM to count 18:45 and 16.30 it keep giving me 11:15 as a result,
although when I highlight 18:45 and 16.30 it shows that the sum is 35:15 in
the bar bellow. Any suggestions?

 

[Guest]

Format the result cell like [h]:mm

Regards,
Stefi


„Rana†ezt írta:

 

[Pete_UK]

You need to format the cell with the result in as Custom --> [h]:mm:ss.
The square brackets around the hours prevent these from being truncated
if they exceed 24.

Hope this helps.

Pete

 

[David Biddulph]

Hello,
I'm searching for a function that count hours, minutes and seconds. When I
use SUM to count 18:45 and 16.30 it keep giving me 11:15 as a result,
although when I highlight 18:45 and 16.30 it shows that the sum is 35:15
in
the bar bellow. Any suggestions?

Format the answer cell as [h]:mm (or [h]:mm:ss if you want to show the zero
seconds too).

And I trust that when you've said 16.30 you meant to say 16:30?

 

[Guest]

Stefi, Pete_UK and David Biddulph,

Thanks for your replyies, that was helpful.
And David, yes, I meant 16:30

Thanks again,
Rana

Hello,
I'm searching for a function that count hours, minutes and seconds. When I
use SUM to count 18:45 and 16.30 it keep giving me 11:15 as a result,
although when I highlight 18:45 and 16.30 it shows that the sum is 35:15
in
the bar bellow. Any suggestions?

Format the answer cell as [h]:mm (or [h]:mm:ss if you want to show the zero
seconds too).

And I trust that when you've said 16.30 you meant to say 16:30?