How to sum and substract hours, minutes and seconds
 

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?

How to sum and substract hours, minutes and seconds
 

Format the result cell like [h]:mm

Regards,
Stefi


€žRana€� ezt Ã*rta:

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?

How to sum and substract hours, minutes and seconds
 

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

Rana wrote:
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?

How to sum and substract hours, minutes and seconds
 

"Rana" wrote in message
...
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?
--
David Biddulph

How to sum and substract hours, minutes and seconds
 

Stefi, Pete_UK and David Biddulph,

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

Thanks again,
Rana

"David Biddulph" wrote:

"Rana" wrote in message
...
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?
--
David Biddulph