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.