Photo: Joe Raedle/Getty Images

Subtracting minutes from a time value is essential for calculating event durations, converting time zones, and many other practical tasks in Excel. The key to a successful calculation is formatting the involved cells correctly and using a simple formula. Below is a clear, step‑by‑step walkthrough.

Step 1: Format the Cell Containing the Original Time

Select the cell that holds the time you want to subtract from. On the Home tab, click Format → Format Cells to open the dialog.

Step 2: Choose a Custom Time Format

In the Number tab, choose Custom. Enter a format that reflects how you want the time displayed. Common options:

• h:mm AM/PM – for 12‑hour clock times like 1:30 PM.
• hh:mm:ss – for full hour, minute, and second display.
• [h]:mm:ss – if you anticipate differences that exceed 24 hours.

Click OK to apply the format.

Step 3: Format the Cell Holding the Minutes to Subtract

Repeat the formatting process for the second cell. Since you will be subtracting a duration, use hh:mm:ss (or [h]:mm:ss for large intervals). This ensures Excel interprets the value as a time duration.

Step 4: Enter the Time Values

Input your values. For example, if the first cell (A1) contains 2:45:00 (2 hours 45 minutes) and the second cell (A2) contains 1:30:00 (1 hour 30 minutes), Excel will treat A2 as the duration to subtract.

Step 5: Subtract Using a Formula

In a third cell (e.g., B1), type the formula:

=A1-A2

Press Enter. The result will display in the format you set in Step 1. If the result is negative, Excel will show a minus sign and the absolute value of the time.

For advanced usage, you can wrap the result in TEXT to control the display format, such as:

=TEXT(A1-A2,"[h]:mm:ss")

This guarantees that durations longer than 24 hours are shown correctly.