The TIMEVALUE function converts a time in the form of text to a serial number. The decimal number is a value ranging from 0 (zero) to 0.99988426, representing the times from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 P.M.).

TIMEVALUE takes 1 required argument and no optional arguments:

Syntax: TIMEVALUE(time_text)

#1)
Using the TIMEVALUE function:
#2)
The arguments for the TIMEVALUE function are:
Argument Required? Description
time_text Required A text string that represents a time in any one of the Excel time formats; for example, "7:15 PM" and "19:15" text strings within quotation marks that represent time.

Summary

The TIMEVALUE function converts a time in the form of text to a serial number.
comments powered by Disqus