# 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

## Related Topics