View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default Convert time format to a decimal

Hi!

Multiply by 24:

=Your_Formula(.............)*24

Biff

"Michele" wrote in message
...
I have a forumula that calculates total time. The results are shown in a
time format (66:30:00). How can we convert this to a decimal (66.5
hours)?
Thank you for your help.

Michele