The TIMEVALUE function in Excel converts a time written as text into Excel time. Excel time is represented by numeric values. For example, time written are text form is 10:30 AM. When using this function, this time is converted to .4375




  • time_text = A date and/or time in a text format. Must be entered into formula directly.

TIMEVALUE Function Usage Example

Let’s look at the following example. By using the function, we can easily convert the text time value into a numerical value. This value can be used


This function can also be used with time and dates. This is shown in the example below.


Common Errors

#VALUE! – Occurs when any of the given arguments cannot be recognized as a valid Excel time. Or, a cell in linked verse written directly into theformula.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top
Send this to a friend