HH:MM:SS to decimal value
 

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

HH:MM:SS to decimal value
 

Your first post came through OK.

Please check there for answers.
--

Regards,

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

"John T Kennedy" wrote in message
...
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

HH:MM:SS to decimal value
 

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

On Dec 28, 4:53*pm, John T Kennedy
wrote:
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

HH:MM:SS to decimal value
 

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

JTK

"John T Kennedy" wrote:

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