MINUTE

Returns the minutes from the DateTime value passed to the function. If the time is not passed to the function along with the date then the function returns the minutes extracted from system time.

Syntax

= MINUTE(value)

Parameters

value

A date time value from which the minutes are to be extracted. The value can contain DateTime as a string (e.g. “02/19/2009 14:30:30.3”, "2009-02-19 14:30:30.3",

 "19 Feb 2009 2:30:30.3 PM ", "Thu, 19 Feb 2009”) or as a DateTime object.

Return Type

Integer

In the case of an error, the function displays an error message: “MINUTE(value): Error message”

Examples

Example

Returns

= MINUTE(“02/19/2009 14:30:30.3”)

30

= MINUTE("2009-02-19 14:30:30.3")

30

= MINUTE (“19 Feb 2009”)

The minutes extracted from system time.

= MINUTE (ShippedDate)

The minutes extracted from the value of ShippedDate. If any entries are NULL then returns the minutes extracted from system time.