returns the date-time serial number, from a time given as text.
TIMEVALUE(timetext)
TIMEVALUE("16:48:00")