#EXCEL MINUS MINUTES HOW TO#

Time is a very confusing element of Excel, but it can be quite powerful once you get to learn it a bit more. You can see how the total Time is 7 hours and 45 minutes and 0 seconds from cell C2, so these elements are simply broken out into their own cell using the Hour, Minute, and Second functions above. NOTE, these functions in the examples below will not return the total minutes or seconds between two times but will simply break that portion of the time out of the original result.

You can also return just the Hours, Minutes, or Seconds from this result by using three simple functions, the HOUR(), MINUTE(), and SECOND() function. Return the Hours, Minutes, or Seconds from the Time Difference in Excel Then, hit OK and everything should work as you expect. Go to the Number tab and then select Custom from the Category section and make sure that you have selected h:mm from the area on the right. Right-click the Time cell and select the Format Cells option.įrom there, a window will open up that looks like this: However, if the display of the new time does not look correct, it should be 7:45 in this case, then we need to make sure the formatting is right. Here we have a start and finish time and I want to see how much time has elapsed between them.Īll you need to do is to subtract the starting time from the finish time: (Note that my version of Excel put the finish time in the 24 hour time format (military time) but that it is still just 5:45 PM.) Step 2: Open parenthesis, select/enter the cell address, then enter a minus(-) symbol.

#EXCEL MINUS MINUTES HOW TO#

Here, youll learn how to get the difference between two times in Excel.Ī common example of this is for when someone starts and finishes work. Step 1: Enter the time in two separate cells as we have shown below.

Excel minus minutes