View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default Converting time period in hours

Hi!

7.3 decimal = 7:18

Do you intend to use 7.21 as a numeric value in other calculations?

Biff

"Jorge" wrote in message
...
How do I convert 7.30 hours into 7.21 (ie 7 hours 21min.) Note I do not
wish
to use the standard hour:minute formatting.