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

1. 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. 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

3. 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.

Posting Permissions

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