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.

Additional Notes

  • MINUTE is key for decomposing time data, especially useful in conjunction with HOUR, SECOND, and other time-manipulating functions.
  • Ensure that the input is a recognized Excel time or datetime format to avoid the #VALUE! error.
  • The function operates on a 60-minute scale, so it’s well-suited for standard time calculations and analysis.

Related Functions

Excel MINUTE function

The Excel MINUTE function extracts the minute from a time value, returning a number from 0 to 59, useful for time data analysis.

Excel TIME function

The Excel TIME function creates a time from hour, minute, and second components, allowing for custom time construction.

Excel SECOND function

The Excel SECOND function extracts the second from a time value, returning a number from 0 to 59, useful for time-based calculations.

Excel HOUR function

The Excel HOUR function extracts the hour from a time value, returning a number from 0 to 23, ideal for time data analysis.

Content Navigation