How do you subtract time in Microsoft Excel??

Question

I am wanting to write a formula in Excel that will tell me how much time (in minutes) from one time to another.

Example: I want to know how long it is, in minutes, from 9:00 p.m. to 6:00 a.m. How do I write a formula in Excel to tell me that?

Thank you to anyone who can help!

Answer 1

Well, you have times that span midnight, so you need to include a date, because the date changed during your time span.

Do you want to reverse the am/pm, just to figure the time? there are the same number of minutes between 9am and 6pm as there are between 9pm and 6am.

Anyway, you need to enter the times and subtract them, but number of minutes is the decimal result you get times 24 for hours and 60 for minutes. The decimal is the fraction of the day. To get the minutes you need to *24*60.

Example:

in A1, 1/1/2000 9:00 pm
in B1, 1/2/2000 6:00 am
in C1, =(+B1-A1)*24*60 - format as general or your favorite comma format. If you include seconds, you can make it two decimals and see the fractions of minutes in decimal form!

Have fun! Date and Time calculations and formatting is tricky!

Answer 2

Subtract Time In Excel

Answer 3

This Site Might Help You.

RE:
How do you subtract time in Microsoft Excel??
I am wanting to write a formula in Excel that will tell me how much time (in minutes) from one time to another.

Example: I want to know how long it is, in minutes, from 9:00 p.m. to 6:00 a.m. How do I write a formula in Excel to tell me that?

Thank you to anyone who can help!

Answer 4

Ensure that the cells that contain the time have been formatted to reflect "time". If you haven't done it yet, well: Right click on the cell, select "Format Cell", under the Number tab select "time" and choose the type you want.

Now the formula for the calculation is very simple;

Ex. 9:00PM is in cell C4 and 6:00AM is in cell C5
In the formula bar type
=C4-C5
Starting time - Ending time
THIS HAS TO BE IN THE CELL WHERE YOU WANT THE ANSWER TO SHOW

Also works for dates, just make sure you have the date format set.

Good luck!

Answer 5

select cells and format them for time
format -> cell

you get a list of different formats.