Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Mon, 25 Nov 2024 23:35:37 +0000

How to Post a Message for Support

Post From: Working in SC Spreadsheet with datetime strings from Trade Activity Log

[2024-01-31 00:58:52]
[Go To First Post]
Sawtooth - Posts: 4120
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)