Calculate Time Differences in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 6, 2023
Download Example Workbook

Download the example workbook

This tutorial will demonstrate how to calculate time differences in Excel & Google Sheets.

time difference


Time Difference

To calculate time differences in Excel simply subtract two times:

Time Difference

Note if you time difference returns a negative number you’ll see this:


To fix the output you can use the ABS Function to calculate the absolute value:



Hours, Minutes, and Seconds Between Times

To display only the hours, minutes, and seconds between times you can use the HOUR, MINUTE, and SECOND Functions:


Hours Between Times

To calculate the number of hours between times, subtract the times and multiply by 24 (24 hours in a day). To calculate only the number of full hours use the INT Function:


Hours BW Time

Minutes Between Times

To calculate the number of minutes between times do the same except multiply by 1440 (24 hours * 60 minutes):


Minutes BW Time

Seconds Between Times

Multiply by 86,400 to calculate the number of seconds between times:


Seconds BW Time

Display Time Difference

You can output a time difference as a string of text using the TEXT Function:


Hours BW Time Text

Calculate Time Differences in Google Sheets

All of the above examples work exactly the same in Google Sheets as Excel.

Time Difference Google

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List