answersLogoWhite

0

You can subtract a time from another time with a standard subtraction formula, as you would do with other numbers. However, there are a few things to be aware of. One is that Excel cannot deal with negative values in time. Also if mixing numbers with time it is important to know that the value 1 is equivalent to a whole day, not an hour or a minute or a second. To do calculations involving those units you need to specifically specify them. The TIME function and some of the other functions that deal with time units are useful. Dealing with calculations with time does take some practice and experience.

User Avatar

Wiki User

7y ago

What else can I help you with?

Related Questions

Can Microsoft Excel subtract?

Yes.


What symbol to use when subtract a number in Microsoft Excel 2010?

You would use a - to subtract a number on a spreadsheet


What does AT-AN mean in Excel?

AT1-AN1 means to subtract the contents of the cell AN1 from AT1, but I am not aware of any specific meaning of AT-AN in Excel.


Do Excel formulas multiply and divide first or add and subtract first?

excel formulas multipy and divide first if i remember corectly


What does daverage do in Excel?

It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.


What kind of operation can be done in Microsoft Excel?

Add, subtract, multiply and divide as well as calculating powers. Pretty much anything you can do in math can be done in Excel.


What are four operators for Microsoft Excel and Word?

There are five operators:add (+)subtract (-)multiply (*)divide (/)exponent (^)


How can you subtract two columns of numbers in excel?

If you want to subtract A1:A23 from C1:C23, you can use this formula:=SUM(C1:C23)-SUM(A1:A23)


Excel helps organize and identify your files by using what?

Excel can access a file manager. Excel helps you organize and identify your files by using Document Properties.


What is an excel query?

Excel can make queries through using the Filter options. They are not known as queries in Excel, but it is what they can do.


How do you average Excel times?

Times in Excel can be averaged using the AVERAGE function. So if you have a list of time in the cells from A2 to A13, the function would be: =AVERAGE(A2:A13)


What are excel characters?

excel characters are symbols like @ instead of using the word at.