Like we already mentioned, there’s no actual command in Excel for subtracting values, you have to use an operator in a formula. That said, we can create individual formulas in cells.

With the date written in and formatted, you can now enter the formula to subtract the date. You would enter that in the appropriate cell for your Excel document.

Excel provides two options for calculating the difference between two times. If you use a simple subtraction operation such as "=C1-A1," select the custom format "h:mm" from the Format Cells options.

Subtract cells using a dash or minus sign (-) Multiply cells an asterisk (*) Divide cells using a slash (/) 2. Track Your Health Excel can help you track calories, exercise and health goals.

4. Addition and Subtraction Lastly, addition and subtraction are handled from left to right. For example, in the formula =5+3-2, Excel first adds 5 and 3, which results in 8.