Returns the minute component of a time value as an integer ranging from 0 to 59.
Söz dizimi
MINUTE(serial_number)Bağımsız değişkenler
serial_numberzorunlu
The time that contains the minute you want to find.
The MINUTE function extracts the minute from a given time value. The time is provided as a serial number or a text string that Excel recognizes as a valid time format.
=MINUTE("10:30:45 AM")→30Extracts the minute part from the specified time string.
Select the cell
Click on the cell where you want to display the result.
Enter the formula
Type =MINUTE(A1) where A1 contains the time value.
The function will return a #VALUE! error if the input cannot be recognized as a valid time.