Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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?

    Thanks in advance,




    What is the correct calculation for this please?
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    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. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Travel Hours (E2K)

    Your question was already answered, but for clarification:
    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. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    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. #5
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Travel Hours (E2K)

    Perfect!!!!! thanks
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

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