convert "37:30:55" to decimal

T

Teaman

I have a field that is formated as time format 37:30:55. I would like to
conver this value to decimal value. for example: 113:30:00, I would like to
read it as 113.5. How do I do that?
Thanks,
Sam
 
D

Dave Peterson

Try multiplying by 24 and formatting the result as General.

=a1*24

If A1 contained 113:30:00.
 
Top