TIMEVALUE
Converts a time in the form of text to a serial number.
Date & TimeDates & Time Calculations
What it does
Converts text time to serial number.
Syntax
TIMEVALUE(time_text)
Arguments
time_text(text) — Time string.
Examples
Text to Time
Convert '6:00 PM'.
FORMULA
=TIMEVALUE("6:00 PM")RESULT
0.75
SAMPLE DATA
| A | |
|---|---|
| 1 | Result |
| 2 | 0.75 |