HH:MM:SS to decimal value

[John T Kennedy]

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

thanks in advance for the help

JTK

 

[RagDyeR]

Your first post came through OK.

Please check there for answers.
--

Regards,

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

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

thanks in advance for the help

JTK

 

[Pete_UK]

No need to post twice.

Try this:

=A1*24

assuming your time is in A1. Format the cell as Number with 2 dp.

Hope this helps.

Pete

 

[John T Kennedy]

Thanks, all for the help. Sorry about the double-post. First timer.

JTK