Hi,

If your cell that totals the hours is in A1 then format A1 to the custom
format D - choose Format, Cells, Number tab, Custom and enter d in the Type
box.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Veronica" wrote:

I am in the process of making a dive chart to monitor that amount of time
spent in the water etc and am in need of help. I have my time spent being
summed up in one cell but need to put another function in another cell to
count the clock reaching 24 hours each time. The sum itself reverts back to
zero once 24 is reached but I need to count each time it reached 24. Any
ideas???