If you want to subtract time in Excel, it helps to understand the way that Excel stores times.
Times are stored as positive decimal values in Excel. It is only the formatting of an Excel cell that causes the numeric value to be displayed as a time, rather than a decimal.
The table below shows examples of decimals and the times that they represent in Excel.
If you have a cell containing a positive decimal value, this can be diplayed as a time, by formatting the cell with a time format.
Further time formatting options can also be introduced if you select the Custom formatting category and enter your own format.
As times are stored as simple decimal values, you can subtract time in Excel in the same way that you can subtract any other numbers. This is shown in the following examples.
The following spreadsheet shows four examples of Excel time subtractions.
The formulas used are shown in column C of the top spreadsheet and the results are shown in the spreadsheet below.
Note that, in the results spreadsheet above, cells C2 and C3 are formatted with the time format hh:mm and cells C4 and C5 use the standard Excel Time format.