TIMEVALUE

Converts a decimal number into time in Excel
Converts a time in the form of text to a serial number

Rational

Converts a decimal number into time.

Description

The Excel TIMEVALUE function returns the time serial number (in decimal) by converting times in text format. For example, the following expression returns =TIMEVALUE(“12:45:30 PM”) as 0.53125 (proportion of total time value of a day).

Syntax

=TIMEVALUE(time_text)

Parameters

time_text – The String containing a valid time

Return Value

The return value is a decimal number or time value as per cell format.

Key Notes

  • Avoid any invalid text input in any of the three-time components, like 24th Hour is not a valid argument.
  • The TIMEVALUE function recognizes the time in the text (manual).
  • Use DATEVALUE function to change a date into a valid date serial number.
  • Excel does not recognize, such as “2:02PM” (no space before PM) instead of “2:02 PM”.
  • Excel store date and time in serial number format, a number from 0 (12:00:00 AM) to 0.999988426 (11.59:59 PM). The serial number can easily get convert by changing cell format to date.

Keep Reading Similar Functions:

Returns a proportion of years for a given range of dates in Excel

YEARFRAC

The YEARFRAC function finds the fraction of years between two dates, like 01-01-2017 and 30-09-2017, use =YEARFRAC(startdate,enddate,2), that returns ‘0.755’.

Read More »
Get a date by entering the year, month, and day in Excel

DATE

The DATE function returns a date value using year, month and date, sequentially. I.e.; to merge all 3 date component, =DATE(2012,12,4) returns “04-12-2012”.

Read More »
Return only the day value of a date in Excel

DAY

The DAY function returns an integer value that represents the day element of a date. I.e.; to extract day component, use =DAY(“08-08-2017”) that returns ‘8’.

Read More »
Return a month before or after the start date in Excel

EDATE

The EDATE function returns a future or past month from a given date. I.e., =EDATE(“31-03-2016”,-1) returns a leap date 29-02-2016 as 2016 is a leap year.

Read More »
Convert text date into a serial value in Excel

DATEVALUE

The DATEVALUE function translates a date into a valid date serial number. I.e; if date is in text format, use =DATEVALUE(“10-6-17”) that returns 42896.

Read More »