English

# 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) * 24 Calculate hours between two times =(End time - Start time) * 1440 Total Minutes between two times =(End time - Start time) * 86400 Total 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.

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.

Step 3: Hit the enter button to find the hours between the two time.

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.

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.

Step 3: Hit enter button to know the minutes left between two time.

Formula 3
Total seconds between times
=(B2-A2)* 86400