Function Reference: HOUR, MINUTE and SECOND
| Syntax | ||
| =HOUR(serial_number) =MINUTE(serial_number) =SECOND(serial_number) |
||
| Purpose / Description | ||
| These functions return the hour of the day (HOUR), minute of the hour (MINUTE) and second of the minute (SECOND) in which a given time or time and date false.. | ||
| Arguments | ||
| Name | Type | Description |
| serial_number | number | A constant, reference or nested expression which provides the serial time number for which the calculation is to be undertaken. |
| Return Values | ||
| Type | Specific Value | Description |
| number | For HOUR: the hour of the day in which the decimal portion of serial_number occurs. For MINUTE, minute of the hour in which the decimal potion of serial_number occurs. For SECOND, the second of the minute on which the decimal portion of serial_number occurs. Numbers returned are always whole number values. |
|
| error | #VALUE! | If serial_number is not a number and cannot be coerced to a number. |
| error | #NUM! | If the value of serial_number is a number outside the range allowed 1900 date system: 0 to 2,958,465 1904 date system: 0 to 2,957,003 |
| error | Any errors referenced by arguments are returned due to propagation of error values. | |
| Notes / Comments / Advice / Warnings | ||
| Notes: | If time values represent fractions of a second, such as when split times are recorded, the SECOND function will round the second and return a whole number. | |
| Advice: | If it is necessary to return the seconds including the decimal of the second, then To return as a time value use instead =MOD(serial_number,1/1440). To return as a number with a whole number of seconds and a decimal for the split time, use instead =MOD(serial_number,1/1440)*86400 See samples workbook for an example. |
|
| Examples: | Open / download sample workbook: HOUR, MINUTE, SECOND.xlsx | |