## How to use the TIMEVALUE function

*Article updated on June 17, 2018*

The TIMEVALUE function returns a decimal number based on a text string. Excel uses decimal numbers between 0 and 0.99988426 formatted as time. 0 (zero) is 12:00:00 AM and 0.99988426 is 11:59:59 P.M.

Formula in cell B3:

=TIMEVALUE("1:48 AM")

### Excel Function Syntax

TIMEVALUE(*time_text*)

### Arguments

time_text |
Required. A text string within quotation marks that represent time, for example "03:23 PM" or "22:21". |

### Comments

The TIMEVALUE function ignores dates , example "22-Aug-2019 6:35 PM" returns 0.774305556.

### Articles with the 'TIMEVALUE' Function

The following 2 articles have formulas that contain the TIMEVALUE function.

In our sequel about weekly schedule it is now time to create a recurring events. This is what we have […]

Introduction This blog post describes how to automatically select a value based on time and date using vba in excel. […]

### Functions in 'Date and Time'

The TIMEVALUE function function is one of many functions in the 'Date and Time' category.

The DATE function returns a number that acts as a date in the Excel environment. The image above shows you […]

The DATEDIF function returns the number of days, months, or years between two dates. The DATEDIF function exists in order to […]

The DATEVALUE function returns an Excel date value (serial number) based on a date stored as text. Excel Function Syntax […]

The DAY function extracts the day as a number from an Excel date. Formula in cell C3: =DAY(B3) Excel Function […]

The DATE function calculates the number of days between two dates. Formula in cell D3: =DAYS(B3,C3) Excel Function Syntax DAYS(end_date, […]

The EDATE function returns a date determined by a start date and a number representing how many months. Use EDATE […]

The EOMONTH function returns an Excel date for the last day of a given month using a number and a start […]

Returns an integer representing the hour of an Excel time value. The returning number is ranging from 0 (12:00 A.M.) […]

Returns a whole number representing the minute based on an Excel time value. The returned number is ranging from 0 […]

Extracts the month as a number from an Excel date. Formula in cell C3: =MONTH(B3) Excel Function Syntax MONTH(serial_number) Arguments […]

The NETWORKDAYS function returns the number of working days between two dates, excluding weekends. It also allows you to ignore […]

The NOW function returns the current date and time. Formula in cell B3: =NOW() Excel Function Syntax NOW() Arguments The […]

Returns an integer representing the second based on an Excel time value. The returning number is ranging from 0 to […]

The TIME function returns a decimal value between 0 (zero) representing 12:00:00 AM and 0.99988426 representing 11:59:59 P.M. Formula in cell […]

The TIMEVALUE function returns a decimal number based on a text string. Excel uses decimal numbers between 0 and 0.99988426 […]

The TODAY function returns the Excel date (serial number) of the current date. Warning! This function is volatile meaning it […]

Converts a date to a weekday number from 1 to 7. Formula in cell D3: =WEEKDAY(B3) Excel Function Syntax WEEKDAY(serial_number,[return_type]) […]

The YEAR function converts a date to a number representing the year in the date. The number is between 1900 […]