This function converts the given time to a serial number value
TIMEVALUE()
Rule | Meaning |
|---|---|
| TIMEVALUE(NOW()) | If this function is called at the time of 13.17:02 it will return the system value 0.553496458334848. |
| TIMEVALUE("16:25:21") | This will return the system value 0.684270833 for the given time. |