How To Calculate Time Difference In Excel

Simply subtract the start time from the end time.

How to calculate time difference in excel. To use Excel for calculations on time differences we need to understand that Excel inextricably mixes time and date. Save your time sheet. The easiest way to calculate a time difference in Excel is to simply subtract one time from the other.

To calculate the difference between two times in the same day simply subtract the start time from the end time. In the Date 1 box enter the first date start date or a reference to the cell containing it. Lets start with a simple formula that calculates the difference between two times in the same day.

Excel can calculate difference between two time in hour or minutes or seconds. Excel dates are serial numbers and a day is equivalent to the number 1. To calculate time differences in Excel simply subtract two times.

End time - Start time 1440 Time difference in seconds. It works because Excel stores date in integers and times in decimal values. In the Difference in box select D.

For example if the difference between start and end time is 4 hours and 30 minutes it should show it as 45 hours. The formula for it is Second time - First time. In other words Excel times are just fractional number s.

This means 1 hour 124 0041666667. Note if you time difference returns a negative number youll see this. Calculate time difference between two dates in Excel.