Support Board

• Support Board |
• Search Board |
• Control Panel |
• View My Posts / Threads |
• Direct Messages

Date/Time: Mon, 25 Nov 2024 23:33:13 +0000

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

[2024-02-01 20:35:40] Link To Thread - Link To Post [Go To First Post]
ForgivingComputers.com - Posts: 960
Column A in a Sierra Spreadsheet Study is in Excel format. The Number underneath can be used instead of MDY-HMS. Put =A3 in K3 and you will see that "2024-02-01 14:15:00" is the same as 45323.59375. Easy to do comparisons. The whole number is days since the beginning of Excel time (1/1/1900) and the fraction is based on a 24-hour day. 24 * 0.59375 = 14.25 = 14:15:00 If you paste the Trade Activity Log into Excel, it will recognize dates and convert them internally. Create a custom Number Format to get milliseconds: m-d-yyyy h:mm:ss.000 Date Time Of Last Edit: 2024-02-01 20:47:26
0x Thank you
Excel Custom Date Format.png / V - Attached On 2024-02-01 20:45:43 UTC - Size: 34.79 KB - 53 views