In this tutorial, you will learn how to calculate the difference between two times in minutes in Excel.
Consider a situation where you have to add two distinct time values to obtain a total. Or, to calculate the total time spent working on a job, you must divide the one-time value by another.
Once you are ready, we can use real-life scenarios to help you understand how to calculate the difference between two times in minutes in Excel.
Table of Contents
SUMIF Cells Not Equal to Value in Excel
Before we begin we will need a group of data to calculate the difference between two times in minutes in Excel.
Step 1
First, you need to have a clean and tidy group of data to work with.
Step 2
In this example, we want to subtract the end time with the start time to calculate how much time was spent on each project. To do that, we will insert the following formula =(B2-A2)*1440. We must multiply the value of B2-A2 by 1,440 to obtain the difference in minutes rather than days because there are 1,440 minutes in a day.
Step 3
Once we are done, you will be able to calculate the difference between two times in minutes.
