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("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
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top