Minute Function

Returns a number between 0 and 59 representing the minute of the hour of the specified time parameter.

Minute (Time)

Parameters

Time  -  (Input, expression, Optional)

The time value to extract the minute value from. If time is specified as a string expression, newlook will be convert it into a time as long as the string is in the form “hh:nn:ss” (it may also include a valid date, e.g. “Feb 1, 1999 10:30:00”).

Return Value

An integer between 0 and 59, or Error if time is not a valid time.

Examples

Minute (“11:22:33”)

Returns 22

Minute (“Feb 1, 1999 11:22:33”)

Returns 22

Minute (Now ())

Returns the current minute

Minute (Null)

Returns Error

Minute (Error)

Returns Error
TIP:

Functions are specifically for use in the Macro Editor. Refer to Microsoft's official VB and JScript documentation for scripting equivalents.

See Also

Date function | DateAdd function | DateDiff function | Day function | Hour function | Minute function | Month function | Now function | Second function | Time function | Week function | WeekDay function | Year function

© 2004-2021 looksoftware. All rights reserved.