View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John T Kennedy[_2_] John T Kennedy[_2_] is offline
external usenet poster
 
Posts: 12
Default 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