Site icon ExcelNotes

How to Use TIMEVALUE Function

The TIMEVALUE Function is to return the decimal number of the time represented by a text string. The decimal number ranges from 0 (12:00:00 am) to 0.999988426 (23:59:59 pm).

Formula:

= TIMEVALUE(time_text)

Explanations:

Time_text is required. A text string that represents a time in the Excel time formats; for example, "10:00 PM" text strings within quotation marks that represent time.

Cautions:

– Date is ignored in the TIMEVALUE function;

– Time value is a portion of a date value that has 24 hours (e.g., 12pm is represented as 0.5 because it is half of a day).

Download: TIMEVALUE Function

Exit mobile version