Package org.apache.poi.ss.formula.functions

Class TimeValue

java.lang.Object

org.apache.poi.ss.formula.functions.Fixed1ArgFunction

org.apache.poi.ss.formula.functions.TimeValue

All Implemented Interfaces:

Function, Function1Arg

public class TimeValue
extends Fixed1ArgFunction

Implementation for the TIMEVALUE() Excel function.

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.

Constructor Summary

Constructors

Constructor	Description
TimeValue()

Method Summary

Modifier and Type	Method	Description
ValueEval	evaluate(int srcRowIndex, int srcColumnIndex, ValueEval dateTimeTextArg)	see Function.evaluate(ValueEval[], int, int)

Methods inherited from class org.apache.poi.ss.formula.functions.Fixed1ArgFunction

evaluate, evaluate

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

TimeValue

public TimeValue()

Method Detail

evaluate

public ValueEval evaluate(int srcRowIndex,
                          int srcColumnIndex,
                          ValueEval dateTimeTextArg)

Description copied from interface: Function1Arg

see Function.evaluate(ValueEval[], int, int)