If you want to subtract time in Excel, it helps if you understand the way that Excel stores times.
Times are actually stored as positive decimal values in Excel. It is only the formatting of an Excel cell that causes a numerical value to be displayed as a time, rather than a decimal.
The table below shows examples of numerical values and the times that they represent in Excel.
decimal 
equivalent time (hh:mm) 

0  00:00 
0.25  06:00 
0.5  12:00 
0.75  18:00 
1.0  24:00 
1.25  30:00 
1.5  36:00 
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.
To format a 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.
For example, the custom formatting style [h]:mm:ss will display more than 24 hours whereas the standard Time format will not.
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 illustrated in the examples below.
The following spreadsheet shows four examples in which Excel times are subtracted.
The formulas used are shown in column C of the top spreadsheet and the results are shown in the spreadsheet below.
Formulas:


Results:

Note that, in the results spreadsheet of the above example, cells C2 and C3 are formatted with the time format hh:mm and cells C4 and C5 use the standard Excel Time format.