Use the minus sign operator or the SUM function to subtract numbers in Excel.

Adding and subtracting in Excel is easy; you just have to create a simple formula to do it. Just remember that all formulas in Excel begin with an equal sign (=), and you can use the formula bar to create …

There are several ways to calculate the difference between two times. There are two approaches that you can take to present the results in the standard time format (hours : minutes : seconds). You use …

Create a simple formula in a cell to add, subtract, multiply, or divide numbers by using +, -, *, and /.

Calculate the difference between two dates. Warning: Excel provides the DATEDIF function in order to support older workbooks from Lotus 1-2-3. The DATEDIF function may calculate incorrect results …

Add or subtract days, months, or years from a date by using a formula or date functions in Excel.

You can create a simple formula to add, subtract, multiply or divide values in your worksheet. Simple formulas always start with an equal sign (=), followed by constants that are numeric values and …

Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.

Let's say that you need to add two different time values together to get a total, or you need to subtract one time value from another to get the total time spent working on a project. As you'll see in the …

Quickly find the difference between two times, control the format of the result, and extend the calculation to a list of times. For example, you can quickly subtract one time from another time, or calculate the …

Calculate the number of days between two dates or calculate a past or future date.