# TIMEVALUE

## 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.

### 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’.

### 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.

### 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”.

### 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’.

### 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.