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

PPMT Function

The PPMT Function in Excel is used to calculate the principle of a given loan payment. If all you a

Read More »

Match Function

Match Function The Match Function searches for a specified value and returns relative position of that value. It’s easier once

Read More »

COUNTIFS Function

The countifs Function is used when you want to count data with multiple criteria. =COUNTIFS (range1, criteria1, [range2], [criteria2], …)

Read More »
Scroll to Top