| | | The "serial_number" can be a time, value, cell reference or a text string in a time format. |
| | | Times may be entered as text strings within quotation marks, as decimal numbers or as results of other formulas or functions. |
| | | If "serial_number" < 0, then #NUM! is returned. |
| | | If "serial_number" is not a valid time or date, then #VALUE! is returned. |
| | | You can obtain the serial number from a time by using the TIME() function. |
| | | You can use the TIMEVALUE() function to return the serial number representing a time in a text format. |
