I have to calculate time in excel  50 miles/30mph=1.67h. How can I format cells to display 1h 40min?
Take the 2minute tour
×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
migrated from stackoverflow.com Dec 1 '12 at 8:04This question came from our site for professional and enthusiast programmers. 


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 


Serega welcome to the forum. Here is a formula you could use:
for example You will need to format the formula cell to Custom, 

