TimeValue(time)
The required time argument is normally a string expression representing a time from 0:00:00 (12:00:00 A.M.) to 23:59:59 (11:59:59 P.M.), inclusive. However, time can also be any expression that represents a time in that range.
You can enter valid times using a 12-hour or a 24-hour clock. For example, "2:24 P.M."
and "14:24"
are both valid time arguments.
If the time argument contains date information, TimeValue doesn't return it. However, if time includes invalid date information, an error occurs.
DateSerial Function | DateValue Function | Hour Function | Minute Function | Now Function | Second Function | TimeSerial Function