Format the cell with [h]:ss
The square brackets prevent mod 24 arithmetic
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Vic1978" wrote in
message ...

Hello,

How is it possible to make a sum of hours?
I just the format 09:45 and wanted to sum several cells. The result is,
that after 24 hours the sum starts at 0 again.
Which kind of formula could I use for the sum of hours?

Thanks a lot
Vicky


--
Vic1978
------------------------------------------------------------------------
Vic1978's Profile:
http://www.excelforum.com/member.php...o&userid=28708
View this thread: http://www.excelforum.com/showthread...hreadid=483899