1. ## Travel Hours (E2K)

Good Morning,

The distance from Point A to Point B is 461. The rate of speed which is traveld to get there is 60 mph. Therefore the TIME it would take the driver to get from Point A to Point B would be 7.68 (461/60) .. 7 hours 68 mins....Since there are 60 mins in an hour the real answer should be 8.08 (68-60 which is the 8th hour and then the remaining 8 mins).

I can use: =INT(461/60) *****************************this will give me the hours but not the mins
I can use: =((461/60)-INT(461/60))*60 *************this will give me the mins but not the hours

If I try to concatenate them (which I shouldn't have to do) then I don't get the decimal and I get 7 or 8 digits long (even when I format it to 0 ). Does anyone have a better suggestion?

What is the correct calculation for this please?

2. ## Re: Travel Hours (E2K)

Good Afternoon,

Excel stores times as a fraction of a day, so to show the result as a time you need to divide the number of hours in the result by 24. In this case:

=(461/60)/24

The result can then be displayed using a time format such as h:mm or h:mm:ss

3. ## Re: Travel Hours (E2K)

Note:
461 miles/ 60 mph = 7.68 hrs

this is not 7 hrs and 68 mins. it is 7 hrs and 68/100 hrs = 7 hrs and 41 mins

Steve

4. ## Re: Travel Hours (E2K)

I would suggest:
[h]:mm or [h]:mm:ss

since this seems more of an elapsed time calculation than a time of day. Using the elapsed time will allow the hours to go above 24.

Steve

5. ## Re: Travel Hours (E2K)

Perfect!!!!! thanks

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•