Take the 2-minute tour ×
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 stackoverflow.com Dec 1 '12 at 8:04

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

add comment

2 Answers

up vote 2 down vote accepted

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

=50/30/24

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

=A2/B2/24

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

share|improve this answer
add comment

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
add comment

Your Answer

 
discard

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