Excel MINUTE() Function
Excel MINUTE() Function
The MINUTE() function in excel converts a serial number to minute (0 - 59).
Syntax
MINUTE (SERIAL_NUMBER)
Parameter
SERIAL_NUMBER (required)- This parameter represents the date or time from which you want to extract minutes.
Category
Date & Time
Return
This function returns the minute from 0 to 59.
Example 1
Objective: Identify today's weekday number basis different return_type value
Col A | Result | Formula |
11/12/2019 22:31 | 31 | =MINUTE(A15) |
10:15 AM | 15 | =MINUTE(A16) |
10:20 PM | 20 | =MINUTE(A17) |
Example 2
Objective: Extract Minute from below given dummy entries
Dummy Entries | Result | Formula |
1-Jan-16 5:37:39 PM | 37 | =MINUTE(A15) |
0.46347 | 07 | = MINUTE(A16) |
23-Feb-18 | 0 | = MINUTE(A17) |
Example 3
Objective: Return current minute value
Result | Formula |
36 | =MINUTE(NOW()) |