Difference Between Times
How to Find the Difference Between Two Times Using Excel
Discover how to use Excel to calculate the difference between two times.
Excel can be used to convert time into seconds.
Time can be converted to seconds by using the number 86400.
Read more about 86400 in the How to Convert Time to Seconds Chapter
How to find the difference between two times?
Step 1) make a sheet and enter values.
We are going to find the seconds in this example between 14:00 (A2) Time A and 16:00 (A3) Time B.
To follow the example, copy the values.
Copy and paste the values into your spreadsheet.
Details:
When you utilize the 86400 number in Excel, the format may alter.
If the format switches to time format, take sure to return it to number format.
Step 2) Convert time to seconds:
Let us multiply the time by 86400.
Select cell C2
Convert time to seconds for Time A:
Calculation
B2(14:00) * G1(86400) = 50400
Repeat the same for Time B: (B3(16:00) * G1(86400))
Step 3) Find the difference in seconds:
Select cell F9
Calculate the difference by subtracting Time B from Time A.
To compute, use the converted seconds (the numbers in Column C).
Calculation
C3(57600) – C2(50400) = 7200 Seconds
Step 4) Convert Seconds to Minutes:
Divide the seconds on 60 to find the minutes.
Select cell F10
Calculation
F9(7200) / G2(60) = 120 Minutes
Step 5) Convert Minutes to Hours:
Divide the minutes on 60 to find the hours.
Select cell F11
Calculation
F9(120) / G3(60) = 2 Hours
Well done!
You’ve been successful in determining the time difference between 14:00 and 16:00.
The correct response in this instance was either 7200 seconds, 120 minutes, or 2 hours.
