Calculate Time Difference Between Two Dates in Minutes in Excel – 6 Methods

The dataset showcases Soldiers’ names ans their training time.

excel time difference between two dates in minutes

Method 1 – Using the Excel Arithmetic Operator to Calculate the Time Difference Between Two Dates in Minutes

Calculate the time difference between two dates in minutes:

Steps:

  • Insert a column to store the duration of training in minutes and enter the following formula in E5.
=1440*(D5-C5)

D5-C5’ converts the time difference between the two dates into days. Each day multiplied by 1440 minutes.

  • Press ENTER to see the time difference between the two dates in minutes in D5 and C5.

excel time difference between two dates in minutes

  • Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

Read More: How to Subtract Dates in Excel to Get Years


Method 2 – Applying the Excel DAYS, HOUR and MINUTE Functions to Calculate Time Difference Between Two Dates in Minutes

Use the DAYS, HOUR, and MINUTE Functions.

Steps:

  • Insert a column to store the duration of training in minutes and enter the following formula in E5.
=1440*DAYS(D5,C5)+60*HOUR(D5-C5)+MINUTE(D5-C5)

excel time difference between two dates in minutes

Formula Breakdown

  • DAYS(D5,C5) returns the days between the dates stored in D5 and C5. The value is multiplied by 1440.
  • HOUR(D5-C5) returns the hour difference between the hours stored in D5 and C5. The vale is  multiplied by 60.
  • MINUTE(D5-C5) returns the minute difference between the minutes stored in D5 and C5.
  • After summing the formulas, the value is 3230 minutes: the time difference between 23rd and 21st April in minutes

  • Press ENTER to see the time difference between the two dates in D5 and C5.

  • Drag down the Fill Handle to see the result in the rest of the cells.

excel time difference between two dates in minutes

This is the output.


Method 3 – Utilizing Combined Functions to Determine the Time Difference Between Two Dates in Minutes in Excel

Use a combination of the INT, HOUR, and MINUTE Functions.

Steps:

  • Insert a column to store the duration of training in minutes and enter the following formula in E5.
=1440*(INT(D5-C5)) + 60*(HOUR(D5-C5))+ MINUTE(D5-C5)

Formula Breakdown

  • INT(D5-C5) returns the days between the dates stored in D5 and C5. The value is multiplied by 1440. The INT function rounds the number to its nearest integer.
  • HOUR(D5-C5) returns the hour difference between the hours stored in D5 and C5. As one hour is equivalent to 60 minutes, we multiply this part of the formula by 60.
  • MINUTE(D5-C5) returns the difference between the minutes stored in D5 and C5.
  • After summing the formulas, the value is 3230 minutes: the time difference between 23rd and 21st April in minutes.

  • Press ENTER to see the time difference between the dates in D5 and C5 in minutes.

excel time difference between two dates in minutes

  • Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

Read More: Difference Between Two Dates in Months in Excel


Method 4 – Using the TEXT Function to Calculate the Time Difference Between Two Dates in Minutes

Use the TEXT Function.

Steps:

  • Insert a column to store the duration of training in minutes and enter the following formula in E5.
=TEXT(D5-C5,"[mm]")

excel time difference between two dates in minutes

The TEXT Function converts the difference between the dates in D5 and C5 to minutes.

  • Press ENTER to see the time difference between the dates in D5 and C5 in minutes.

  • Drag down the Fill Handle to see the result in the rest of the cells.

excel time difference between two dates in minutes

This is the output.


Method 5 – Using the NOW Function to Determine the Time Difference Between the Current and the Previous Date in Minutes 

Use the NOW Function.

Steps:

  • Insert a column to store the duration of training in minutes and enter the following formula in E5.
=NOW()-D5

The formula will return the exact time difference between the current date and the day stored in D5 in days.

  • Press ENTER to see the time difference between the current date and the date in D5 in days.

excel time difference between two dates in minutes

  • Drag down the Fill Handle to see the result in the rest of the cells.

  • Convert the days to minutes: Home >> Number Format >> More Number Formats…

excel time difference between two dates in minutes

  • In Format Cells, select Custom.
  • Enter [mm] in ‘Type:’.
  • Click OK.

The time difference will be displayed in minutes.

excel time difference between two dates in minutes

  • Use the following formula to convert days to minutes.
=TEXT(NOW()-D5,"[mm]")

This is the output.


Method 6 – Applying the TODAY Function to Calculate the Time Difference Between Two Dates in Minutes

Use the TODAY Function.

The TODAY Function returns the current date starting at 12:00 AM.

Steps:

  • Insert a column to store the duration of training in minutes and enter the following formula in E5.
=TEXT(TODAY()-D5,"[mm]")

excel time difference between two dates in minutes

The TODAY()-D5 formula returns the difference between the current date and the date in D5 in days. The TEXT Function converts this difference to minutes.

  • Press ENTER to see the time difference between the current day and the date in D5 in minutes.

  • Drag down the Fill Handle to see the result in the rest of the cells.

excel time difference between two dates in minutes

This is the output.

Read More: How to Minus Number of Days or a Date from Today in Excel


Practice Section

Practice here.


Download Practice Workbook


<< Go Back to Subtract Dates | Calculate Dates | Date-Time in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Meraz Al Nahian
Meraz Al Nahian

Md. Meraz Al Nahian has worked with the ExcelDemy project for over 1.5 years. He wrote 140+ articles for ExcelDemy. He also solved a lot of user problems and worked on dashboards. He is interested in data analysis, advanced Excel, statistics, and dashboards. He also likes to explore various Excel and VBA applications. He completed his graduation in Electrical & Electronic Engineering from Bangladesh University of Engineering & Technology (BUET). He enjoys exploring Excel-related features to gain efficiency... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo