Support Board
Date/Time: Tue, 04 Mar 2025 18:15:22 +0000
Separating Date and Time in Spreadsheet
View Count: 763
| [2021-12-24 20:26:05] |
| User148824 - Posts: 10 |
|
Hi, The 'Date Time' is the first column in DefaultSpreadsheet. It shows as the Date and Time in the same column: 2021-12-23 15:58:00 Can the Date and Time be separated into two separate columns in the Sierra chart spreadsheet? |
| [2021-12-25 05:10:49] |
| Sawtooth - Posts: 4179 |
|
Can the Date and Time be separated into two separate columns in the Sierra chart spreadsheet?
To extract the Date only, use the INT function in a Formula Column's row 3:=INT(A3) To extract the Time only, use the FRACTIME function in a Formula Column's row 3: =FRACTIME(A3) https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#INT_Function https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#FRACTIME_Function |
| [2021-12-25 05:19:51] |
| |
|
There is also this function: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#INTDATE_Function Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: