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

Syntax:

 =TIMEVALUE(time_text) 

Arguments:

  • 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

TIMEVALUE Function

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

TIMEVALUE 2

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 Reply

FLOOR Function

The FLOOR function in Excel rounds a given number down to the nearest specified multiple. Unlike the MROUND function, the

Read More »

CONCAT Function

The Excel CONCAT Function joins a range of cells or individual strings of data. This function was introduced in 2016

Read More »

SUMIF Function

The SUMIF function in Excel sums up particular cells based upon certain criteria. Criteria is specified using logical operators. Common

Read More »
Scroll to Top