View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default HH:MM:SS to decimal

See answer elsewhere.

Pete

On Dec 28, 4:51*pm, John T Kennedy
wrote:
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