Sign up ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have to calculate time in excel - 50 miles/30mph=1.67h. How can I format cells to display 1h 40min?

share|improve this question

migrated from Dec 1 '12 at 8:04

This question came from our site for professional and enthusiast programmers.

2 Answers 2

up vote 2 down vote accepted

If you have an existing calculation then you can do an additional division by 24, e.g.


or if you have distance in A2, speed in B2 use this formula in C2


Ensure that you custom format the result cell as [h]:mm

share|improve this answer

Serega welcome to the forum. Here is a formula you could use:

="Decimal Value Location"/24 

for example =A1/24

You will need to format the formula cell to Custom, hh:mm and you should be good to go!

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.