Return the minute of the hour (a number from 0 to 59) given a time value.
Syntax Minute(time_value) Key time_value A valid time.
The minute() function can be used in VBA or in an SQL query.
Examples
Dim intDemo as integer
intDemo = minute(dtmShiftEnd)
intDemo = minute(#08:55:30 AM#)
Select * from orders where minute(Order_date) = 30;
“For a moment, nothing happened. Then, after a second or so, nothing continued to happen” ~ Douglas Adams
Related:
Day - Return the day of the month.
DatePart - Return part of a given date.
Second - Return the seconds of the minute