Support Board
Date/Time: Tue, 24 Feb 2026 18:20:01 +0000
Post From: Separating Date and Time in Spreadsheet
| [2021-12-25 05:10:49] |
| Sawtooth - Posts: 4313 |
|
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 |