Audi Log TIME (ISO-8601) Conversion
Wondering if anyone has done the work to convert the Quickbase Audit Log Timestamp to local time? I export the logs via CSV and then am working towards a process to convert the "2024-10-28T15:53:25...
ChatGPT to the rescue.
=TIMEVALUE(MID(A2,12,8)) - TIME(7,0,0)=DATEVALUE(LEFT(A2,10))
