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.
No comments:
Post a Comment