Microsoft Office Tutorials and References
In Depth Information
Using TIMEVALUE to Convert Text Times to Real Times
Figure 11.41.
Figure 11.41. The formulas in column B use
to convert the text
entries in column A to times. If there is no leading zero before entries with
The formulas in column B use TIMEVALUE
TIMEVALUE to convert the text
entries in column A to times. If there is no leading zero before entries with
minutes and seconds, the formula produces an unexpected result.
minutes and seconds, the formula produces an unexpected result.
Caution
There are a few examples of text that TIMEVALUE cannot recognize.
One common example is when there is no space before the AM or PM.
For example, 11:00PM returns an error. To solve this particular
problem, use Replace to change PM to PM and to change
AM to AM .
The ExcelTroubleshooting sectionlaterinthischapterdis-
cusses how to solve the problem of misinterpreting the
TIMEVALUE function.
Search JabSto ::




Custom Search