Examples
MINUTE("007:14:21")
: 14
MINUTE(TIMENOW() - "00:00:00")
: Minutes since the top of the hour; the current minute of the hour. See also: TIMENOW().
Minutes in Duration
MINUTE() merely extracts the minutes component from a Duration value; it does not compute the number of minutes the Duration value represents in total. To compute the total minutes comprising a Duration value:
(
(HOUR([Duration]) * 60)
+ MINUTE([Duration])
+ (SECOND([Duration]) / 60.0)
)
(HOUR([Duration]) * 60)
computes the number of minutes represented by the hours component.MINUTE([Duration])
gathers the number of minutes specified by the minutes component.(SECOND([Duration]) / 60.0)
computes the fractional minute represented by the seconds component.
Common Problems
MINUTE(NOW())
(or any DateTime or Time value in place of NOW()) causes Expression Assistant to complain, Parameter 1 of function MINUTE is of the wrong type. The argument must be a Duration value, not a DateTime or Time value. To fix, convert a DateTime value to a Time value with TIME(), then subtract a zero time to convert a Time value to a Duration value: MINUTE(TIME(NOW()) - "00:00:00")
. See also: NOW(), TIME().
Syntax
MINUTE( how-long )
Arguments
- how-long (Duration)
Return Value
Number: the number of whole minutes explicitly specified by how-long if identifiable, or 0 if a minute is not found.
MINUTE(...)
is equivalent to (NUMBER(INDEX(SPLIT(TEXT(...), ":"), 2)) + 0)
when ...
is a Time value. See also: INDEX(), NUMBER(), SPLIT(), TEXT().