TIME VALUE
What Does It Do?
This function will show an actual time based on a piece of text which looks like a time. It is useful when data is imported from other applications, such as from mainframe computers, which convert all values to text.
Syntax
=TIMEVALUE(Text)
Formatting
The result will be shown as a number representing the time a fraction of the day. Formatting can be applied for either the 12 or 24 hour clock system.
| Text | Time | |
| 14:30:59 | 0.604849537 | =TIMEVALUE(C4) |
| 14:30:59 | 14:30:59 | =TIMEVALUE(C5) |
| 14:30:59 | 2:30:59 PM | =TIMEVALUE(C6) |