Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

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

You must log in to answer this question.