try
right click on the cell/s
Format Cells
Select Time
In Type, choose 37:30:55
OK

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"dolphin1986" wrote:

I need to calculate hours. I have a formula set up for part of my equation
where I'm adding up the total hours that something took place for the month
(by entering each occurance and then summing), but I need to take the total
hours for the month which in one instance is 58 hrs and 7 minutes and
subtract the occurances from that to find out the difference. How can I
enter the 58:07 without it giving me a January 2, 1900 date and 10:07 as the
time?