How to Calculate time difference in Google Sheets(Quick & Easy Guide)

In this tutorial you will learn How to Calculate time difference in Google Sheets

To calculate time difference in google Sheets you can use the below funtions:

=HOUR(B2-A2)

=MINUTE(B2-A2)

How to Calculate time difference in Google Sheets : Step by Step Guide

Here are the steps with examples to calculate time difference in Google Sheets.

#Calculate time difference in Google Sheets using Functions

You can use the in-built functions provided by google sheets to calculate the time difference.

=HOUR(B2-A2) - to get the difference only in hours
=MINUTE(B2-A2) - to get the difference only in  minutes 
=SECOND(B2-A2) - to get the difference only in seconds

These functions only perform time difference calculation for a period of 24 hours, 60 minutes, and 2 seconds. The formulas will return errors if the time difference is greater than these bounds.

Let’s see the above formulas in action😃 :

Step 1 : Open google sheets and prepare your dataset

Open google sheets where you need to perform the calculation .

In this example we will use the below dataset.

Step 2 : Apply the formula

Now we will apply the above formula as shown below.

Time Difference in hours

Select the cell C2 and apply the formula =HOUR(B2-A2) and press enter

Drag the blue square icon on the cell C2 to apply the formula donwards across the remaining cells.

Time Difference in minutes

Select the cell D2 and apply the formula =MINUTE(B2-A2) and press enter

Time Difference in seconds

Select the cell E2 and apply the formula =SECOND(B2-A2) and press enter.

Calculate time difference in Google Sheets using the TEXT function

Another method to calculate the time difference in Google Sheets is using the TEXT function:

Use the below formula to calculate the time difference using TEXT function in Google Sheets.

=TEXT(B2-A2,"h") - to calculate in hours

=TEXT(B2-A2,"h:mm") - to calculate in minutes

=TEXT(B2-A2,"h:mm:ss") - to calculate in hours, minutes, and seconds

Calculate time difference in hours using TEXT function