# 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:

syntax
`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

ABC
1Start TimeMinute ComponentResult
29:30 AM`=MINUTE(A2)`30
310:45 AM`=MINUTE(A3)`45
42: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

ABCD
1TaskTime SpentMinute ComponentResult
2Data Analysis1:45`=MINUTE(B2)`45
3Report Writing2:30`=MINUTE(B3)`30
4Meeting0: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

ABCD
1Sale IDTime of SaleMinute ComponentResult
20019:15 AM`=MINUTE(B2)`15
300211:30 AM`=MINUTE(B3)`30
40031: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

ABCD
1Employee IDClock-in TimeMinute ComponentResult
2E0018:05 AM`=MINUTE(B2)`5
3E0028:30 AM`=MINUTE(B3)`30
4E0039: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

ABCD
1Delivery IDTime of DeliveryMinute ComponentResult
2D00110:20 AM`=MINUTE(B2)`20
3D0022:45 PM`=MINUTE(B3)`45
4D0035: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

ABC
1Start TimeMinute ComponentStarts at Half-Hour?
29:30 AM`=MINUTE(A2)``=IF(B2=30, "Yes", "No")`
310:45 AM`=MINUTE(A3)``=IF(B3=30, "Yes", "No")`
42: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

ABCD
1TaskTime SpentMinute ComponentExceeds Limit?
2Data Analysis1:45`=MINUTE(B2)``=IF(C2>60, "Yes", "No")`
3Report Writing2:30`=MINUTE(B3)``=IF(C3>60, "Yes", "No")`
4Meeting0: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

ABCD
1Sale IDTime of SaleMinute ComponentSalesperson
20019:15 AM`=MINUTE(B2)``=VLOOKUP(C2, SalespersonTable, 2, FALSE)`
300211:30 AM`=MINUTE(B3)``=VLOOKUP(C3, SalespersonTable, 2, FALSE)`
40031: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

ABCD
1Employee IDClock-in TimeMinute ComponentLate?
2E0018:05 AM`=MINUTE(B2)``=IF(C2>0, "Yes", "No")`
3E0028:30 AM`=MINUTE(B3)``=IF(C3>0, "Yes", "No")`
4E0039: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

ABCD
1Delivery IDTime of DeliveryMinute ComponentAverage Minute
2D00110:20 AM`=MINUTE(B2)``=AVERAGE(C\$2:C2)`
3D0022:45 PM`=MINUTE(B3)``=AVERAGE(C\$2:C3)`
4D0035: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

ABCDE
1TaskCompletion TimeMinute ComponentDeadlineOn-Time?
2Task 19:15 AM`=MINUTE(B2)`9:30 AM`=IF(C2<=30, "Yes", "No")`
3Task 211:45 AM`=MINUTE(B3)`12:00 PM`=IF(C3<=30, "Yes", "No")`
4Task 32: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

ABCD
1Call IDTime of CallMinute ComponentCalls at This Minute
2C0019:15 AM`=MINUTE(B2)``=COUNTIF(C\$2:C2, C2)`
3C0029:15 AM`=MINUTE(B3)``=COUNTIF(C\$2:C3, C3)`
4C0039: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

ABCD
1Event IDStart TimeMinute ComponentMax Start Minute
2E0019:15 AM`=MINUTE(B2)``=MAX(C\$2:C2)`
3E00210:45 AM`=MINUTE(B3)``=MAX(C\$2:C3)`
4E0032: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

1. 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.
2. The MINUTE function can be combined with other date and time functions for more complex calculations.
3. Be careful when entering time values as text strings. Make sure to use the correct format (for example, “6:45 PM”).