You can calculate the time difference between two times in minutes using Google Sheets in many ways. We’ll cover the two easiest.
Contents
Preparation – Properly Format Your Times
Before you use the formulas in this tutorial, ensure your times are valid. There are several formats; choose the one that works best for you.
You can use the ISDATE function to check each date as shown above.
Calculations – Find the Difference Between Two Times in Minutes
Once your data is ready, you can find the minutes using either of these easy formulas. Each technique has different advantages.
First formula: =ROUND((B2A2)*24*60)
The most simple formula simple subtracts the starting time from the ending time. Subtracting two times in Google Sheets results in the number of days between them. Since you are looking for minutes instead of days, multiply this difference by 24
to get to hours, then by 60
to arrive at minutes.
Second formula: =TEXT(B3A3,"[M]")&" minutes")
This next formula converts the result to a text string using the TEXT function. Using a text string allows you to add the unit to the end of the result to make it clear to the spreadsheet reader. So, as seen in the image above, the result is shown as 1342 minutes instead of just 1,342.00.
⚠️ Be sure to add the square brackets around the [M]
if you are calculating a longer duration. These brackets change the format from a point in time to a duration. This allows the hours to exceed 60.
Practice – Get a Copy of the Template
Make a copy of this template to see the examples in a live Google Sheet.
Advanced – Use TIMEDIF for Other Time Units
If you want a more complex output, such as years, weeks, or months, consider using the TIMEDIF addon.
 Enter datetimes in two columns
 Click “CALCULATE ACTIVE RANGE”
 The durations are calculated and placed in your spreadsheet without formulas.
Related Tutorials

Types of Date and Time Functions in Google Sheets
The date and time functions in Google Sheets can be grouped into different categories based on their purpose.

DAYS360 Function – Google Sheets
The DAYS360 function calculates days using 30 days for each month. When using a 365day daily interest rate computation, the interest rate is divided by 365 and multiplied by the principal for each day you calculate interest. When using a 360day year method, the interest rate is divided by 360 and multiplied by the principal…

Show a Date as a Month Name – Google Sheets
Learn two methods to display your dates as the month’s name in your spreadsheet.

DATEVALUE Function – Google Sheets
The DATEVALUE function accepts a date value in any valid format and returns it as a serial number. Spreadsheets store dates and times as serial numbers in Google Sheets, so they work in formulas (you can add March plus June). You can use the DATEVALUE function to prepare dates to be sorted, filtered, or used in formulas.…

Show the Day of the Week as Text – Google Sheets
This tutorial shows you two ways to display your dates as the day of the week in your spreadsheet. The default is to show the month, day, and year together. Therefore, you will have to make a few changes depending on the type of output you want. Grab a copy of this template to follow…

DAY Function – Google Sheets
The DAY function is a simple date function that extracts just the day from a given time. If you work with times but only care about the day, this function lets you get rid of everything else. Typically you will find this function combined with others to return a number for further calculation. This function…