Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Apr 2001
    Location
    new york city
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculate Difference in Time (Excel 2000/ Windows 2000)

    Is it possible to format two columns for time and then use a third column to determine how long the duration is? For example, if you were to have a time sheet; could you put a column for time in and a column for time out with a third column for duration of work?

    Thanks.

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Calculate Difference in Time (Excel 2000/ Windows 2000)

    Hi Meredith,

    if your start times are in A1 and end times are in B1, this can be as simple as putting =B1-A1 into C1 and having all of these cells formatted in an appropriate time format.

    There have been many posts in this forum on how to set up/maintain timesheets. If you do a search on "time sheet", "timesheet" or "attendance", I'm sure you'll find a lot of useful material.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculate Difference in Time (Excel 2000/ Windows 2000)

    The short answer is yes, just subtract the start time (in A1) from the end time (in B1) with the a formula like =B1-A1 and format the cell containing the result with the custom format [h]:mm. That custom format will give you the elapsed time in hours and minutes and the hours can be greater than 24. If you want the time in hours and fractional hours (2 hours and 30 minutes would display as 2.50, the use the formula =(B1-A1)*24 and format the cell as a number with two decimal places. This is also what you want to do if you are going to multiply the elapsed time by a rate to get the pay.

    One additional point. If the starting time could be in one day and the ending time in a subsequent day, then the cells containing the start and end times should also contain the dates. For example a start time would be 2/13/03 11:00 pm and the end time would be 2/14/03 8:30 am.
    Legare Coleman

Posting Permissions

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