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