**MINUTE Function in Microsoft Excel**

**Part 1: Introduction**

**Definition**

The **MINUTE function** in Microsoft Excel is a date and time function that returns the minutes of a given time value.

**Purpose**

The purpose of the **MINUTE function** is to extract the minute component from a time value, which can be useful in various time-related calculations in business, such as calculating time spent on tasks, time tracking, and scheduling.

**Syntax & Arguments**

The syntax of the **MINUTE function** is as follows:

`MINUTE(serial_number) `

**Explanation of Arguments**

`serial_number`

: This is a required argument. It is the time that contains the minute you want to find. Times may be entered as text strings within quotation marks (for example, “6:45 PM”), as decimal numbers (for example, 0.78125, which represents 6:45 PM), or as results of other formulas or functions (for example, TIMEVALUE(“6:45 PM”)).

**Return Value**

The **MINUTE function** returns the minute as an integer, ranging from 0 to 59.

**Remarks**

Time values are a portion of a date value and are represented by a decimal number. For example, 12:00 PM is represented as 0.5 since it is half of a day.

**Part 2: Examples**

Let’s look at examples of how the **MINUTE function** can be used in a business context.

**Example 1**

**Purpose**

To find the minute component of the start time of a meeting.

**Data Tables and Formulas**

A | B | C | |
---|---|---|---|

1 | Start Time | Minute Component | Result |

2 | 9:30 AM | `=MINUTE(A2)` | 30 |

3 | 10:45 AM | `=MINUTE(A3)` | 45 |

4 | 2:15 PM | `=MINUTE(A4)` | 15 |

**Explanation**

In this example, column A shows the start times of various meetings. We use the **MINUTE function** in column B to extract the minute component of each start time. The results are displayed in column C.

**Example 2**

**Purpose**

To calculate the minute component of the time spent on various tasks.

**Data Tables and Formulas**

A | B | C | D | |
---|---|---|---|---|

1 | Task | Time Spent | Minute Component | Result |

2 | Data Analysis | 1:45 | `=MINUTE(B2)` | 45 |

3 | Report Writing | 2:30 | `=MINUTE(B3)` | 30 |

4 | Meeting | 0:50 | `=MINUTE(B4)` | 50 |

**Explanation**

In this example, we have the time spent on various tasks in column B. We use the **MINUTE function** in column C to extract the minute component of each time spent. The results are displayed in column D.

**Example 3**

**Purpose**

To find the minute component of the time at which sales were made.

**Data Tables and Formulas**

A | B | C | D | |
---|---|---|---|---|

1 | Sale ID | Time of Sale | Minute Component | Result |

2 | 001 | 9:15 AM | `=MINUTE(B2)` | 15 |

3 | 002 | 11:30 AM | `=MINUTE(B3)` | 30 |

4 | 003 | 1:45 PM | `=MINUTE(B4)` | 45 |

**Explanation**

In this example, we have the time of sales in column B. We use the **MINUTE function** in column C to extract the minute component of each time of sale. The results are displayed in column D.

**Example 4**

**Purpose**

To calculate the minute component of the time at which employees clock in.

**Data Tables and Formulas**

A | B | C | D | |
---|---|---|---|---|

1 | Employee ID | Clock-in Time | Minute Component | Result |

2 | E001 | 8:05 AM | `=MINUTE(B2)` | 5 |

3 | E002 | 8:30 AM | `=MINUTE(B3)` | 30 |

4 | E003 | 9:00 AM | `=MINUTE(B4)` | 0 |

**Explanation**

In this example, we have the clock-in times of employees in column B. We use the **MINUTE function** in column C to extract the minute component of each clock-in time. The results are displayed in column D.

**Example 5**

**Purpose**

To find the minute component of the time at which deliveries were made.

**Data Tables and Formulas**

A | B | C | D | |
---|---|---|---|---|

1 | Delivery ID | Time of Delivery | Minute Component | Result |

2 | D001 | 10:20 AM | `=MINUTE(B2)` | 20 |

3 | D002 | 2:45 PM | `=MINUTE(B3)` | 45 |

4 | D003 | 5:00 PM | `=MINUTE(B4)` | 0 |

**Explanation**

In this example, we have the time of deliveries in column B. We use the **MINUTE function** in column C to extract the minute component of each delivery time. The results are displayed in column D.

**Example 6**

**Purpose**

To find if a meeting starts at the half-hour mark (e.g., 10:30, 2:30, etc.).

**Data Tables and Formulas**

A | B | C | |
---|---|---|---|

1 | Start Time | Minute Component | Starts at Half-Hour? |

2 | 9:30 AM | `=MINUTE(A2)` | `=IF(B2=30, "Yes", "No")` |

3 | 10:45 AM | `=MINUTE(A3)` | `=IF(B3=30, "Yes", "No")` |

4 | 2:15 PM | `=MINUTE(A4)` | `=IF(B4=30, "Yes", "No")` |

**Explanation**

In this example, we use the **MINUTE function** to extract the minute component of each start time. We then use the **IF function** to check if the meeting starts at the half-hour mark.

**Example 7**

**Purpose**

Calculate the total time spent on tasks and find if it exceeds a certain limit.

**Data Tables and Formulas**

A | B | C | D | |
---|---|---|---|---|

1 | Task | Time Spent | Minute Component | Exceeds Limit? |

2 | Data Analysis | 1:45 | `=MINUTE(B2)` | `=IF(C2>60, "Yes", "No")` |

3 | Report Writing | 2:30 | `=MINUTE(B3)` | `=IF(C3>60, "Yes", "No")` |

4 | Meeting | 0:50 | `=MINUTE(B4)` | `=IF(C4>60, "Yes", "No")` |

**Explanation**

In this example, we use the **MINUTE function** to extract the minute component of each time spent. We then use the **IF function** to check if the time spent on a task exceeds 60 minutes.

**Example 8**

**Purpose**

To find the minute component of the time sales were made, look up the corresponding salesperson.

**Data Tables and Formulas**

A | B | C | D | |
---|---|---|---|---|

1 | Sale ID | Time of Sale | Minute Component | Salesperson |

2 | 001 | 9:15 AM | `=MINUTE(B2)` | `=VLOOKUP(C2, SalespersonTable, 2, FALSE)` |

3 | 002 | 11:30 AM | `=MINUTE(B3)` | `=VLOOKUP(C3, SalespersonTable, 2, FALSE)` |

4 | 003 | 1:45 PM | `=MINUTE(B4)` | `=VLOOKUP(C4, SalespersonTable, 2, FALSE)` |

**Explanation**

In this example, we use the **MINUTE function** to extract the minute component of each time sale. We then use the **VLOOKUP function** to look up the salesperson’s name from a separate table (SalespersonTable) based on the minute component.

**Example 9**

**Purpose**

To calculate the minute component of the time at which employees clock in and determine if they are late.

**Data Tables and Formulas**

A | B | C | D | |
---|---|---|---|---|

1 | Employee ID | Clock-in Time | Minute Component | Late? |

2 | E001 | 8:05 AM | `=MINUTE(B2)` | `=IF(C2>0, "Yes", "No")` |

3 | E002 | 8:30 AM | `=MINUTE(B3)` | `=IF(C3>0, "Yes", "No")` |

4 | E003 | 9:00 AM | `=MINUTE(B4)` | `=IF(C4>0, "Yes", "No")` |

**Explanation**

In this example, we use the **MINUTE function** to extract the minute component of each clock-in time. We then use the **IF function** to check if the employee clocked in after the hour’s start (i.e., the minute component is greater than 0).

**Example 10**

**Purpose**

To find the minute component of the time at which deliveries were made and calculate the average delivery minute.

**Data Tables and Formulas**

A | B | C | D | |
---|---|---|---|---|

1 | Delivery ID | Time of Delivery | Minute Component | Average Minute |

2 | D001 | 10:20 AM | `=MINUTE(B2)` | `=AVERAGE(C$2:C2)` |

3 | D002 | 2:45 PM | `=MINUTE(B3)` | `=AVERAGE(C$2:C3)` |

4 | D003 | 5:00 PM | `=MINUTE(B4)` | `=AVERAGE(C$2:C4)` |

**Explanation**

In this example, we use the **MINUTE function** to extract the minute component of each time delivery. We then use the **AVERAGE function** to calculate the average delivery minute up to that point.

**Example 11**

**Purpose**

To find the minute component of the time at which tasks were completed and determine if they were completed within a certain time frame.

**Data Tables and Formulas**

A | B | C | D | E | |
---|---|---|---|---|---|

1 | Task | Completion Time | Minute Component | Deadline | On-Time? |

2 | Task 1 | 9:15 AM | `=MINUTE(B2)` | 9:30 AM | `=IF(C2<=30, "Yes", "No")` |

3 | Task 2 | 11:45 AM | `=MINUTE(B3)` | 12:00 PM | `=IF(C3<=30, "Yes", "No")` |

4 | Task 3 | 2:00 PM | `=MINUTE(B4)` | 1:45 PM | `=IF(C4<=30, "Yes", "No")` |

**Explanation**

In this example, we use the **MINUTE function** to extract the minute component of each completion time. We then use the **IF function** to check if the task was completed before or at the half-hour mark.

**Example 12**

**Purpose**

To find the minute component of the time at which calls were made and count the number of calls made within a certain minute.

**Data Tables and Formulas**

A | B | C | D | |
---|---|---|---|---|

1 | Call ID | Time of Call | Minute Component | Calls at This Minute |

2 | C001 | 9:15 AM | `=MINUTE(B2)` | `=COUNTIF(C$2:C2, C2)` |

3 | C002 | 9:15 AM | `=MINUTE(B3)` | `=COUNTIF(C$2:C3, C3)` |

4 | C003 | 9:30 AM | `=MINUTE(B4)` | `=COUNTIF(C$2:C4, C4)` |

**Explanation**

In this example, we use the **MINUTE function** to extract the minute component of each time of the call. We then use the **COUNTIF function** to count the number of calls made at the same minute.

**Example 13**

**Purpose**

To find the minute component of the time at which events start and find the maximum start minute.

**Data Tables and Formulas**

A | B | C | D | |
---|---|---|---|---|

1 | Event ID | Start Time | Minute Component | Max Start Minute |

2 | E001 | 9:15 AM | `=MINUTE(B2)` | `=MAX(C$2:C2)` |

3 | E002 | 10:45 AM | `=MINUTE(B3)` | `=MAX(C$2:C3)` |

4 | E003 | 2:30 PM | `=MINUTE(B4)` | `=MAX(C$2:C4)` |

**Explanation**

In this example, we use the **MINUTE function** to extract the minute component of each start time. We then use the **MAX function** to find the maximum start minute up to that point.

**Part 3: Tips and Tricks**

- Remember that the
**MINUTE function**only returns the minute component of a time value. If you need the hour or second component, use the HOUR or SECOND function. - The
**MINUTE function**can be combined with other date and time functions for more complex calculations. - Be careful when entering time values as text strings. Make sure to use the correct format (for example, “6:45 PM”).