View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dazp1970 dazp1970 is offline
external usenet poster
 
Posts: 2
Default converting a decimal to time

I want to be able to convert a decimal into time, and am completely stuck!

As an example, I have in cell A1 4.9 (this number represents 4.9hrs).

I want a formula that will calculate the hours and minutes for me, and show
the result in normal time format. In my example above the answer I would be
looking for is 04:54 (i.e. four hours and 54 minutes).

I have trawled these threads and have found many posts on how to convert
time to a decimal. I want to do the reverse.

Any ideas?

Darrell.