Syntax:
TIMEVALUE(date_text)
The TIMEVALUE function converts a time that is stored as text to a serial number that Excel
recognizes as a date/time. For example, the formula =TIMEVALUE("1/1/2008 12:00") returns 0.5, the
serial number of the time 12:00. The date element is ignored (see DateValue).
Remember, though, that your computer's system date setting may
cause the results of a TIMEVALUE function to vary from this example.
The TIMEVALUE function is helpful in cases where a worksheet contains dates/times in a text format that you want to filter, sort, or format as times, or use in time calculations.
To view a date serial number as a time, you must apply a times format to the cell.
| Access | Constructor and Description |
|---|---|
| public |
| Modifier and Type | Method and Description |
|---|---|
| public ValueEval | evaluate(int srcRowIndex, int srcColumnIndex, ValueEval dateTimeTextArg)
Implements org. |
| private NumberEval |
| LOG | back to summary |
|---|---|
| private static final Logger LOG | |
| TimeValue | back to summary |
|---|---|
| public TimeValue() | |
| evaluate | back to summary |
|---|---|
| public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval dateTimeTextArg) Implements org. Doc from org. see
| |
| parseTimeFromDateTime | back to summary |
|---|---|
| private NumberEval parseTimeFromDateTime(String dateTimeText) throws EvaluationException | |