Support Board
Date/Time: Tue, 04 Nov 2025 17:31:48 +0000
Post From: Working in SC Spreadsheet with datetime strings from Trade Activity Log
| [2024-01-31 00:58:52] |
| Sawtooth - Posts: 4285 |
|
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) |