Menu
EXCEL TIMEVALUE FUNCTION
Excel TIMEVALUE Function Introduction
This function returns the decimal equivalent of a text string’s time. The decimal number represents times from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 P.M.).
Description of Excel TIMEVALUE Function
Syntax:
=TIMEVALUE (time_text)
Parameter list:
time text – a text string that indicates a time in any of the Microsoft Excel time formats; for example, the text strings “6:45 PM” and “18:45” within quotation marks signify time.
Step By Step Guide of TIMEVALUE Function
Formula | Description | Result |
=TIMEVALUE (“8:24 AM”) | Decimal part of a day, with only the time specified | 0.35 |
=TIMEVALUE (“22-Aug-2011 9:35 AM”) | Decimal part of a day, with date and time specified | 0.399305556 |
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
