Support Board
Date/Time: Thu, 03 Jul 2025 14:35:20 +0000
Post From: Working in SC Spreadsheet with datetime strings from Trade Activity Log
| [2024-01-31 00:58:52] |
| Sawtooth - Posts: 4231 |
|
You can do it using 5 Formula Columns: O3: 2023-12-15 10:01:36.000 P3: =VALUE(MID(O3,0,4)) Q3: =VALUE(MID(O3,5,2)) R3: =VALUE(MID(O3,8,2)) S3: =DATE(P3,Q3,R3) |