TIMEVALUE

Get a valid time from a text string

Sponsored Link

TIMEVALUE

Purpose 

Get a valid time from a text string

Return value 

A decimal number representing a particular time in Excel.

Syntax 

=TIMEVALUE (time_text)

Arguments 

  • time_text - A date and/or time in a text format recognized by Excel.

Usage notes 

Time_text should be supplied in a text format that Excel can recognize, for example, "6:45 PM" or "17:30".

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.

Note: date information is ignored.

Sponsored Link

0 votes. 0 / 5