Difference between revisions of "ELTimeToDateTime s"
Jump to navigation
Jump to search
(→Usage) |
m (Reverted edits by 176.8.90.7 (talk) to last revision by 194.84.116.138) |
||
| Line 3: | Line 3: | ||
The integer portion of the DateTime value indicates the number of days that have elapsed since January 1st, 1900, and the fractional portion of the DateTime value indicates the fraction of the day that has passed since midnight. | The integer portion of the DateTime value indicates the number of days that have elapsed since January 1st, 1900, and the fractional portion of the DateTime value indicates the fraction of the day that has passed since midnight. | ||
| − | + | ==== Usage ==== | |
| + | <syntaxhighlight>ELTimeToDateTime_s(HHmmss)</syntaxhighlight> | ||
| + | Where: [[HHmmss]] - a numerical expression specifying the time | ||
| + | |||
==== Example ==== | ==== Example ==== | ||
<syntaxhighlight>ELTimeToDateTime_s(101525) will return a value of 0.427372685, corresponding to the specified | <syntaxhighlight>ELTimeToDateTime_s(101525) will return a value of 0.427372685, corresponding to the specified | ||
Revision as of 12:42, 13 February 2012
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 January 1st, 1900, 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
