Exceljet

Quick, clean, and to the point

Excel TIMEVALUE Function

Excel TIMEVALUE function
Summary 

The Excel TIMEVALUE function converts a time represented as text into a proper Excel time. For example, the formula =TIMEVALUE("9:00 AM") returns 0.375, the numeric representation of 9:00 AM in Excel's time system. Numeric time values are more useful than text since they can be directly manipulated with formulas and pivot tables.

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.
Version 
Excel 2003
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.

Related functions 
Excel DATEVALUE function
Excel DATEVALUE Function

The Excel DATEVALUE function converts a date represented as text into a proper Excel date. For example, the formula =DATEVALUE("12/31/2015") returns a serial number in the Excel date system that represents December 31, 2015. Proper Excel dates...

500 Formulas | 101 Functions

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.