Thread: HH:MM:SS to decimal value
View Single Post
  #1   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
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
Reply With QuoteReply With Quote