TIME VALUE

Posted on 22-01-2020 , by: admin , in , 0 Comments

TIME VALUE

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)

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.

Leave a comment