time value

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

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

Add a Checkbox in Excel

Learn to add a checkbox in excel. This tutorial will provide a simple way to gain more usability from standard spreadsheet. In order to add

Read More »

Randomly Sort Data in Excel

Learn to randomly sort data in Excel by using this simple trick. The RAND Function can be used to randomly sort a data set by applying a numerical number.

Read More »

Learn Faster!