Microsoft Excel has a wide range of options to **subtract minutes from time** using different formulas. We will discuss those methods of subtraction in this tutorial.

**Table of Contents**hide

**Download Practice Workbook**

Download this practice workbook to exercise while you are reading this article.

**Generate Current Time in the Desired Format in Excel**

We can subtract hours, minutes, or seconds from any time in Excel. First, we input the current time using **the NOW function**. Here, we will show the subtraction of minutes from time only.

**Step 1:**

- Go to
**Cell B5**and enter the**NOW**function.

`=NOW()`

**Step 2:**

- Press the
**Enter**button.

Both time and date values are shown here. We want time values only. Let’s change the format of the cell.

**Step 3:**

- Press
**Ctrl+1**now. - Set
**h:mm:ss AM/PM**format from the**Custom**section of the**Number**tab.

**Step 4:**

- Now, press
**OK**.

**Step 5:**

- We will subtract
**30**minutes from the time value. Enter**30**in**Cell C5**.

So, our dataset is ready. Now, we will subtract time from this value in the following methods.

**Note:**

As we have used the **NOW** function to get the current time, the Input time changes continuously.

**7 Methods to Subtract Minutes from Time in Excel**

**1. Subtract Fraction of Minutes from Time in Excel**

In this method, we will subtract a fraction of minutes from time. First, we need to relate the minutes and a day.

We all know that

**1 day = 24 hours **

**1 hour = 60 minutes **

**So, 1 minute=1/(24*60) day **

**=1/1440 day**

So, when we subtract minutes from a time in the day unit, we will multiply the minutes by **1/1440**.

**Step 1:**

- Move to
**Cell D5**. - Write the formula below.

`=B5-C5/1440`

**Step 2:**

- Now, press the
**Enter**button.

Subtraction is performed successfully.

**Read More: How to Subtract Hours from Time in Excel (2 Easy Ways)**

**2. Apply Excel TIME Function to Subtract Minutes from Time**

**The TIME function** modifies any number put in the formula to a time value.

Now, execute the following steps.

**Step 1:**

- Go to
**Cell D5**. - Enter the following formula in the cell.

`=B5-TIME(0,C5,0)`

**Step 2:**

- Now, press
**Enter**.

**Read More: Timesheet Formula in Excel (5 Examples)**

**3. Combine TIME, HOUR, MINUTE, and SECOND Functions to Subtract Minutes**

**The HOUR function** returns a range of numbers** 0-23** in hour format.

**The MINUTE function** converts values **0 **to **59** in minute format.

**The SECOND function** works like the **MINUTE **function, i.e. it converts values **0 **to **59** in second format.

Now, follow the steps below.

**Step 1:**

- Write the following formula in
**Cell D5**.

`=TIME(HOUR(B5),MINUTE(B5)-C5,SECOND(B5))`

**Step 2:**

- Then click the
**Enter**button.

**Related Content: How to Add Minutes to Time in Excel (5 Easy Ways)**

**Similar Readings:**

**How to Calculate Turnaround Time in Excel Excluding Weekends (3 Ways)****Calculate Average Turnaround Time in Excel (4 Methods)****How to Calculate Production per Hour in Excel (4 Ways)****Calculate Percentage of Time in Excel (4 Suitable Examples)****How to Calculate Cycle Time in Excel (7 Examples)**

**4. Use of the MOD function to Subtract Minutes**

**The MOD function** provides remainders after division.

We will apply this **MOD **function in this method. As the minute input is in the **General **format, we need to use the fraction formula. But when the minute input is in a proper format, i.e. the minute format, the fraction formula is not needed.

**Step 1:**

- Go to
**Cell D5**. - Write the following formula in the cell.

`=MOD(B5-C5/1440,1)`

**Step 2:**

- Now, press the
**Enter**button.

We get the result by inserting the fraction formula with the **MOD **function.

**Alternative Formula to Subtract Minutes Using the MOD Function:**

We can avoid the fractionation in the formula if we follow the procedure below.

**Step 1:**

- Copy
**Row 5**and paste it into**Row 6**.

**Step 2:**

- Click on
**Cell C6**and press**Ctrl+1**to change the format. - Choose
**h:mm**format and then press**OK**.

Look at **Cell C6**.

**Step 3:**

- Enter the following formula on
**Cell D6**.

`=MOD(B6-C6,1)`

**Step 4:**

- Finally, press the
**Enter**button.

Both results are the same.

**Read More: Excel formula to calculate hours worked & overtime [with template]**

**5. Subtract Minute from Time Using a Simple Formula**

We will perform subtraction using a simple formula. We will first change the format of the time value into **h:mm**.

**Step 1:**

- Click on
**Cell C5**. - Press the right button of the mouse.
- Choose
**Format Cells**from the list.

We can also do this by pressing **Ctrl+1**.

**Step 2:**

- Choose
**h:mm**format from the**Custom**section. - Then, press
**OK**.

This is what will look like.

**Step 3:**

- Write the following formula in
**Cell D5**.

`=B5-C5`

**Step 4:**

- Press the
**Enter**button.

**Read More: How to Subtract Date and Time in Excel (6 Easy Ways)**

**6. ****Insert Excel TEXT Function to Subtract Minutes from Time**

**The TEXT function** transforms any number into text in a given format

Now carefully apply the following steps.

**Step 1:**

- Move to
**Cell D5**. **Copy**and**Paste**the formula below.

`=TEXT(B5-C5,"h:mm:ss")`

**Step 2:**

- Press the
**Enter**button.

Here, we select the format as **h:mm:ss**. But we could use any format as per our necessity.

**Read More: How to Calculate Elapsed Time in Excel (8 Ways)**

**7. Formula to Direct Subtract Minutes from Time**

We can directly subtract minutes from the time by entering the subtrahend in a suitable formula.

**Step 1:**

- Go to
**Cell D5.** - Enter the formula below.

Here, we did not use any cell reference for the subtrahend.

**Step 2:**

- Now, press the
**Enter**button.

We get the desired result.

**Read More: How to Subtract and Display Negative Time in Excel (3 Methods)**

**Conclusion**

In this article, we described some easy methods on how to subtract minutes from time in Excel. I hope this will satisfy your needs. Please have a look at our website **Exceldemy.com** and give your valuable suggestions in the comment box.