Thread: HH:MM:SS to decimal
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
I need to convert a time of more than 24 hours, like 37:45:00 to a decimal
value, 37.75, but don't know the proper function.

Thanks in advance for your help!

JTK
Reply With QuoteReply With Quote