Count hours, minutes or seconds between two times

Tutorial to find how many hours, minutes, seconds are there between two times.

Formula

Here is a simple tutorial which helps to calculate the difference between two times in a single time unit ie., hours ,minutes or seconds. Using the formula provided below count hours, minutes or seconds between two times.

=(End time - Start time) * 24Calculate hours between two times
=(End time - Start time) * 1440Total Minutes between two times
=(End time - Start time) * 86400Total seconds between times

Formula 1
Calculate hours between two times
=(B2-A2) * 24
Step 1:
Enter the time in two separate cells as we have shown below.
Count Hours Minutes Or Seconds Between Two Times

Step 2: Open parenthesis, select/enter the cell address, then enter a minus(-) symbol followed by selecting the cell in which you have entered the end value. Close the parenthesis. Leave a space and type * 24.
Count Hours Between Two Times Step1
Step 3: Hit the enter button to find the hours between the two time.
Count Hours Between Two Times Step2

Formula 2
You can find the total minutes between two times by using the below mentioned formula.
=(B2-A2)*1440
Step 1: Enter the time in separate cell.
Count Minutes Between Two Times Step1
Step 2: Open parenthesis, select/enter the cell address, then enter a minus(-) symbol followed by selecting the cell in which you have entered the end value. Close the parenthesis. Leave a space and type * 1440.
Count Minutes Between Two Times Step2
Step 3: Hit enter button to know the minutes left between two time.
Count Minutes Between Two Times Step3
Formula 3
Total seconds between times
=(B2-A2)* 86400


Related Topics