Excel - HH:MM:SS to decimal value

Asked By JohnTKenned on 28-Dec-07 11:53 AM
I need to convert a time value of more than 24 hours, like 37:45:00 to a
decimal value, 37.75, but do not know the fuction to use.

thanks in advance for the help

JTK




RagDyeR replied on 28-Dec-07 11:57 AM
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 replied on 29-Dec-07 02:09 PM
No need to post twice.

Try this:

=3DA1*24

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

Hope this helps.

Pete
JohnTKenned replied on 28-Dec-07 12:09 PM
Thanks, all for the help. Sorry about the double-post.  First timer.

JTK