MINUTE function

Category: Date and time
Introduced: Excel 2003

Summary

Converts a serial number to a minute

Syntax

MINUTE(serial_number) The MINUTE function syntax has the following arguments:
• Serial_number Required. 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")).

Example

=MINUTE(A2)

Microsoft Support Page

https://support.microsoft.com/en-us/office/minute-function-af728df0-05c4-4b07-9eed-a84801a60589

Back to Functions