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())



ADVERTISEMENT
ADVERTISEMENT