TIMEVALUE Function (Functions in Excel)
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. |
0 comments:
Post a Comment