Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Nov 2002
    Location
    London, Gtr London, England
    Posts
    496
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Find number of hours between two times (2K)

    A simple problem but I can't remeber how to do it....

    If I have e.g. Start Time = 09:00 and End Time = 17:30
    I want to get the result 8.5 hours (not 08:30)

    can you help?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Find number of hours between two times (2K)

    Say A1 contains 09:00 and A2 contains 17:30.
    In the cell that should display the number of hours between them, enter the formula =24*(A2-A1), then select Format | Cells... In the Number tab, select General or Number.
    Explanation: Excel stores times as fractions of a day (e.g. 06:00 = 0.25); to convert to hours, multiply by the number of hours in a day.

Posting Permissions

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