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. |