+1 888 340 6572

ELTimeToDateTime s

From MultiCharts

Returns the fractional portion of a double-precision decimal DateTime value corresponding to the specified time, including seconds. The time is specified in the 24-hour HHmmss format, where 130000 = 1:00:00 PM.

The integer portion of the DateTime value indicates the number of days that have elapsed since December 30th, 1899, and the fractional portion of the DateTime value indicates the fraction of the day that has passed since midnight.

Usage

ELTimeToDateTime_s(HHmmss)

Where: HHmmss - a numerical expression specifying the time

Example

ELTimeToDateTime_s(101525)  will return a value of 0.427372685, corresponding to the specified 
time of 10:15:25 AM 

ELTimeToDateTime_s(154500)  will return a value of 0.656250000, corresponding to the specified 
time of 3:45:00 PM