The MINUTE function converts a time_code to a minute. The minute is calculated using 1 hour as a basis, running from 0 to 59. A time code increment of 1 corresponds to 1 day (or 1,440 minutes). The argument for MINUTE can be in either text or time code format.
The following examples all returns 12, that is the 12th minute after the 13th hour of the day.
Formula |
Returns |
MINUTE(0.55) |
12 |
MINUTE(1.55) |
12 |
MINUTE("13:12") |
12 |
See also: