MINUTE

MINUTE(time)

Returns the minutes from a given time (Integer).

time

The time you want the minute from (Variant).

REMARKS

* The required time argument is any Variant, numeric expression, string expression, or any combination, that can represent a time.
* If time contains Null, then Null is returned.
* The value that is returned is between 0 and 59.
* You can use the HOUR function to return the hour from a time.
* You can use the NOW function to return the current system date and time.
* You can use the SECOND function to return the seconds from a time.
* You can use the TIME function to return the current system time.
* The equivalent .NET function is [[Microsoft.VisualBasic.DateAndTime.Minute]]
* For the Microsoft documentation refer to learn.microsoft.com

Debug.Print Minute(VBA.Time())      '= volatile  
Debug.Print Minute("09:3:20")       '= 3  
Debug.Print Minute("09:34:20")      '= 34  
Debug.Print Minute("11:15:06")      '= 15  
Debug.Print Minute("11:15:06 AM")   '= 15  
Debug.Print Minute("11:15:06 AM")   '= 15  
Debug.Print Minute("22:00:00")      '= 0  
Debug.Print Minute("1:1:1")         '= 1  

Dim tmTime As Variant 
tmTime = #6:25:39 AM# 
Debug.Print Minute(tmTime)          '= 25