You are here: Function Reference > Alphabetical Listing > M > Minute

Minute

Use this function to extract the number of minutes from a time.

Minute (Time, Format)

Parameter	Description
Time	Enter a valid time string. The system assumes your entry is in the time format specified in the Format parameter. The default is the current time.
Format	Enter a valid time format string that describes the Time parameter. The default is time format 1 (HH:MM:SS).

Here are some examples:

(Assume the current time is 03:05:09.)

Function	Result	Explanation
Minute( )	05	Defaults to the current time and extracts 05
Minute ("03:07:09")	07	Reads the given time and extracts 07

Function

Result

Explanation

Minute( )

Defaults to the current time and extracts 05

Minute

("03:07:09")

Reads the given time and extracts 07