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.