Note: The other languages of the website are Google-translated. Back to English

Excel TIMEVALUE Function

Supposing there is a text formatting time list in your worksheet, how can you convert the time list to proper time? Actually the TIMEVALUE function can help you solve the problem. This article provides syntax and detailed sample of TIMEVALUE function to help you easily use it in Excel.

Description of TIMEVALUE function

Syntax of TIMEVALUE function

Arguments of syntax

Usage of TIMEVALUE function


Description of TIMEVALUE function

The Microsoft Excel TIMEVALUE function can help to return decimal number of a time which was formatted as text string.


Syntax of TIMEVALUE function

=TIMEVALUE(time_text)


Arguments of syntax

  • Time-text: The text formatting of a time or datetime which can be recognized by Excel.

1) Directly reference to a time or date and time cell which formatted as text: =TIMEVALUE(B3).

2) Directly enter time as text string and embraced with quotation marks: =TIMEVALUE("10:30 PM").

Or =TIMEVALUE("25-Dec-2018 10:30 PM") for date and time text format.


Usage of TIMEVALUE function

This section will show you detailed steps to use the TIMEVALUE function in Excel.

1. Select a cell you want to output the time result, enter formula =TIMEVALUE(B3) into the Formula Bar and press the Enter key. See screenshot:

Then drag the Fill Handle down to apply the formula to other cells as below screenshot shown.

Remark: #VALUE! will occur if the referenced time cannot be recognized as a valid time by Excel.

Comments (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations

Follow Us

Copyright © 2009 - www.extendoffice.com. | All rights reserved. Powered by ExtendOffice. | Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Protected by Sectigo SSL