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.

Subtraction methods in Excel aren't the quickest or simplest, but if you need to get it done, we can show you how to subtract in Excel. Here's how.

Subtracting isn’t as straightforward in Excel as it seems, simply because there’s no actual command to subtract numbers. Instead, you have to use a formula with the subtraction operator.

For example, type the formula = (b3-b2)*24 in cell B4. This formula will subtract quitting time from starting time and multiply the result times 24.