Microsoft Excel Functions & Formulas

Use the TIMEVALUE function to convert text

to time

In this example, a text string has to be converted to a valid time.

Columns A and C contain different start and end times as part of a

standardized text string. It is possible to extract the times and con-

vert them to valid time values that can be used as the basis for

calculations. To convert text into a valid time, use the

TIMEVALUE function. This function returns the decimal number

of the time represented by a text string. The decimal number is a

value ranging from 0 to 0.99999999, representing the time from

0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 P.M.).

4

To extract and convert text to time:

1. ...