The TIMEVALUE function in Microsoft Excel is a Date and Time function, and its purpose is to convert a time in the form of text to a serial number. It is used to convert text representations of times into decimal values.
The formula for the function is
The syntax for the TIMEVALUE function is:
Time_text: A time in a text format that Excel recognizes.
Using the TIMEVALUE function in Excel is not complicated once you know the formula. In this tutorial, we will explain how to use the TIMEVALUE function.
How to use TIMEVALUE function in Excel
To use the TIMEVALUE function in Excel, follow these steps:
- Launch Microsoft Excel
- Create a table or use an existing table from your files
- Place the formula into the cell you want to see the result
- Press the Enter Key
Launch Microsoft Excel.
Create a table or use an existing table from your files.
Type the formula into the cell you want to place the result =TIMEVALUE(“1:24 AM”)
Then press the Enter key to see the result.
The cell below contains both a time and data type the formula =TIMEVALUE(“9/3/21 4:30 PM”) into a cell; you would want to place the result.
Press enter to see the result.
There are two other methods to use the TIMEVALUE function.
Method one is to click the fx button on the top left of the excel worksheet.
An Insert Function dialog box will appear.
Inside the dialog box in the section, Select a Category, select Date and Time from the list box.
In the section Select a Function, choose the TIMEVALUE function from the list.
Then click OK.
A Function Arguments dialog box will open.
In the Time_text entry box, input into the entry box cell “1:24 AM”.
Method two is to click the Formulas tab, click the Time and Date button in the Function Library group, and select TIMEVALUE from the drop-down menu.
A Function Arguments dialog box will appear.
We hope this tutorial helps you understand how to use the TIMEVALUE function in Microsoft Excel.