HH:MM:SS to decimal
 

I need to convert a time of more than 24 hours, like 37:45:00 to a decimal
value, 37.75, but don't know the proper function.

Thanks in advance for your help!

JTK

HH:MM:SS to decimal
 

Multiply by 24.
Make sure you format the cell to General or Number.

=A1*24
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"John T Kennedy" wrote in message
...
I need to convert a time of more than 24 hours, like 37:45:00 to a decimal
value, 37.75, but don't know the proper function.

Thanks in advance for your help!

JTK

HH:MM:SS to decimal
 

See answer elsewhere.

Pete

On Dec 28, 4:51*pm, John T Kennedy
wrote:
I need to convert a time of more than 24 hours, like 37:45:00 to a decimal
value, 37.75, but don't know the proper function.

Thanks in advance for your help!

JTK