Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

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 »
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 »
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 »
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 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 »