ExcelCSE.com

Menu
  • Excel 101
  • Excel Functions
  • Excel Formula
  • Contact Us
How to Use Excel > Excel Functions > Excel TIMEVALUE Function

Excel TIMEVALUE Function

How to Use Excel TIMEVALUE Function
Table of contents :
  • What is the Excel TIMEVALUE Function?
  • TIMEVALUE Syntax
  • How to Use TIMEVALUE Function in Excel
  • TIMEVALUE Example

Excel TIMEVALUE Function

What is the Excel TIMEVALUE Function?

The Excel TIMEVALUE function converts a time represented as text into a valid Excel time. Returns the decimal number ranging from 0 (zero) representing the times 0:00:00 (12:00:00 AM) to 0.999988425925926 representing the times 23:59:59 (11:59:59 PM).

TIMEVALUE Syntax

TIMEVALUE(time_text)

time_text, required, a time represented as text in one of Excel time formats. For example, “6:45 PM” and “18:45” is a text that represents the same TIME value but different format.

Usage notes:

  • Any DATE value in the time_text argument is ignored.
  • TIME value is a part of a DATE value, represented as a decimal number. For more information, please read “How does Excel Store Dates and Times”.

How to Use TIMEVALUE Function in Excel

For example, there is data like the picture below, date and time data in column A. What is the result of the TIMEVALUE function that uses data in column A as the time_text argument.

Excel TIMEVALUE

TIMEVALUE Function #1

=TIMEVALUE(A2)

Cell A2 contains a time represented in a text with HH:MI format. The result is 0.28125.

TIMEVALUE Function #2

=TIMEVALUE(A3)

Cell A3 contains a time represented in the text but with a different format HH:MI AM/PM. The result is 0.78125.

TIMEVALUE Function #3

=TIMEVALUE(A4)

Cell A4 contains the same data as cell A2, why does the TIMEVALUE function return an error #VALUE!? Look closely, the data in cell A2 is by default left aligned, this is a sign that data in cell A2 is a text.

Instead, the data in cell A4 is by default right aligned; this is a sign that data in cell A4 is a TIME value instead of a text.

TIME value in time_text argument causes the TIMEVALUE function to return an error.

TIMEVALUE Function #4

=TIMEVALUE(A5)

Just like cell A4, cell A5 contains a TIME value, but with a different format. The result remains an error #VALUE!.

TIMEVALUE Function #5

=TIMEVALUE(A6)

Cell A6 contains a text represents a date and time. The TIMEVALUE function only converts the time represented as text and ignores the date. The result is the same as cell A2, 0.28125

TIMEVALUE Function #6

=TIMEVALUE(A7)

Cell A7 contains a text that represents the date and time together, like cell A6 but with a different format. The result is the same as cell A3, 0.78125.

TIMEVALUE Function #7

=TIMEVALUE(A8)

Cell A8 contains DATE and TIME values simultaneously. Same as cell A4 and cell A5. The time_text argument that is filled with DATE and TIME value will return an error #VALUE!.

The complete results of Excel TIMEVALUE function in column B can be seen in the picture below.

TIMEVALUE Function

TIMEVALUE Example

Another article using or explain about TIMEVALUE Function

Another Date/Time Function Example

Another article about Date/Time Function
  • Excel WEEKDAY Function
  • Excel TIMEVALUE Function
  • Excel TIME Function
  • Excel HOUR Function
  • Excel MINUTE Function
  • Excel SECOND Function
  • Excel DATE Function
  • Excel YEAR Function
  • Excel MONTH Function
  • Excel DAY Function
Share
Tweet
Google+
Email
Prev Article
Next Article

Related Articles

Multiple IF Statements in Excel
What is Multiple IF Statements? Multiple IF statements are also …

Multiple IF Statements in Excel

Excel AVERAGEA Function
What is the Excel AVERAGEA Function? The excel AVERAGEA function …

Excel AVERAGEA Function

Excel HOUR Function
What is the Excel HOUR Function? The Excel HOUR function …

Excel HOUR Function

INDEX MATCH Excel
INDEX MATCH Formula You can use the INDEX function and …

INDEX MATCH – Excel VLOOKUP Alternative

Excel AVERAGE Function
What is the Excel AVERAGE Function? The Excel AVERAGE function …

Excel AVERAGE Function

Tags:Date/Time Function Excel Time Functions Excel TIMEVALUE How To Use TIMEVALUE Function In Excel TIMEVALUE Formula TIMEVALUE Function In Excel

Categories

  • Excel 101
  • Excel Formula
  • Excel Functions

Recent Posts

  • Get the Original Price from Percentage Increase/Decrease
  • How to Add/Subtract Percentage in Excel
  • How to Extract Day, Month and Year from Date in Excel
  • How to Add Seconds, Minutes and Hours to a Time in Excel
  • How to Add Days, Weeks, Months and Years to a Date in Excel
  • How to Calculate Time Difference in Excel
  • Calculate Number of Days, Weeks, Months and Years Between Two Dates in Excel
  • Flash Fill Excel
  • Paste Special Excel
  • Excel TEXTJOIN Function
  • Excel CONCAT Function
  • Excel CONCATENATE Function
  • Excel REPLACE Function
  • Excel SUBSTITUTE Function
  • Excel REPT Function
  • Excel FIND Function
  • Excel SEARCH Function
  • Excel MID Function
  • Excel RIGHT Function
  • Excel LEFT Function

ExcelCSE.com

The Ultimate Guide How to Use Excel Better
Copyright © 2023 ExcelCSE.com
Contact Us - Privacy Policy - Sitemap | Theme by MyThemeShop.com

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh