less than 1 minute read


We all know DFIR loves spreadsheets for timelines, but copying out times, dates and converting data types can be a pain. This post aims to show the formulas I commonly use in excel to help this out

Date wont convert when doing formulas, or sort not working


Convert from ISODate (ISO 8601) to DATE


Convert from DATE to ISODate (ISO 8601)


Change timezone

=MOD(A1+(<Zone Offset>/24),1)