converting a decimal to time

D

dazp1970

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.
 
T

Trevor Shuttleworth

Darrell

divide the number by 24 and format the cell as hh:mm:ss

For example, if A1 has 4.9, B1 would be =A1/24 formatted as hh:mm:ss is
04:54:00

Regards

Trevor
 
S

squenson via OfficeKB.com

Time is represented internally by a fraction of 1, where 1 is 24 hours. So 12
hours is 0.5, 6 hours 0.25, 1 hour is 0.0416667, etc.

In your case, the formula is =A1/24, and format the cell with a time format.
You should now see 04:54 in the cell.

Stephane.
 
D

David Biddulph

The previous threads that you read will have told you that to convert from
Excel time format to decimal hours you would need to multiply by 24.
The answer to your question, therefore, is that to convert decimal hours to
Excel time format you need to *divide* by 24.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top