Excel MINUTE function

Summary

The Excel MINUTE function extracts the minute component from a time value, returning it as a number between 0 and 59. This function is highly useful in parsing and analyzing time data, particularly when you need to isolate the minute part of a time for further calculations or in combination with other date and time functions.
Syntax
```				```
=MINUTE(serial_number)
```
```
• serial_number: A valid Excel time or datetime from which the minute is to be extracted.
Return value
A number representing the minute part of the time, within a range of 0 to 59.

How to use

The MINUTE function is straightforward to apply. Provide a valid Excel time, and the function will return the minute part of that time. It can be used with times entered as text (e.g., “5:30 PM”), in decimal format, or derived from other formulas or cells containing time.

Examples

Simple MINUTE
Basic Minute Extraction: Extracting the minute from a specified time:
```				```
=MINUTE("13:45")
```
```
This formula extracts and returns the minute part of 1:45 PM, which is 45.
MINUTE and TIME
Setting Specific Hour and Second: Adjusting time to a specific hour and second, keeping the same minute:
```				```
=TIME(9, MINUTE(A1), 0)
```
```
Assuming A1 contains a time value, this formula sets the hour to 9 and the second to 0, while keeping the minute from A1.
MINUTE with Date Value
Extracting Minute from a DateTime Value: Retrieving the minute component from a combined date and time:
```				```
=MINUTE(B1)
```
```
If B1 contains a datetime value (e.g., “2021-07-15 16:20”), this formula extracts and returns the minute part of the datetime, which is 20 in this case.