Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 28 Apr 2024 07:27:03 +0000
Post From: Time in spreadsheets
| [2013-12-30 04:07:03] |
| T44 - Posts: 363 |
|
Sierra Chart Spreadsheets store Dates and Times as double precision floating point numbers which represent the time since 1900-Jan-1 at 00:00. The integer part of the floating-point number represents the days and the fractional part, to the right of the decimal place, represents the time. This is exactly the same way as Excel and OpenOffice Calc represent date and Time values. This is called a Serial Date Time value.
http://www.sierrachart.com/index.php?l=doc/doc_WorksheetFunctions.html#SerialDateTimeValues See also: http://www.sierrachart.com/index.php?l=doc/doc_SCDateTime.html Sorry I don't have a specific example for you. Perhaps the simplest would be to read the current time, extract the hour, and check for hour==16. This can be done simply enough in ASCIL by referring to the example code, and then perhaps you could link this in with the sheet? |