Related Function:

The TIMEVALUE function creates a time in serial number format from a date and/or time in an Excel text format. TIMEVALUE will return a decimal number between 0 and 0.99988426, representing 12:00:00 AM to 11:59:59 PM.

Syntax

=TIMEVALUE(time_string)

Arguments

Argument Description
time_string A text string that represents a time in any one of the Microsoft Excel time formats; e.g. “6:45 PM” and “18:45” text strings within quotation marks that represent time

Note: Date information will be ignored.

Examples

  A B C D
1   Formula Result Notes
2   =TIMEVALUE(“10:30 AM”) 0.4375 Decimal part of a day representing 10:35 AM
3   =TIMEVALUE(“12:00 PM”) 0.5 Decimal part of a day, with only the time specified
4 6:00 PM =TIMEVALUE(A4) 0.75 Decimal part of a day, with only the time specified
5 10/2/2014  18:00 =TIMEVALUE(A5) 0.75 Decimal part of a day, with date and time specified

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if the supplied time_string cannot be recognized as a valid time