Handy DFIR Excel Formulas
source link: https://angry-bender.github.io/blog/Handy-Excel-Formulas/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Handy DFIR Excel Formulas
February 18, 2022
less than 1 minute read
IntroductionPermalink
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 workingPermalink
=TEXT(A1,"YYYY-MM-DDTHH:MM:SS")
Convert from ISODate (ISO 8601) to DATEPermalink
=DATEVALUE(MID(A1,1,10))+TIMEVALUE(MID(A1,12,8))
Convert from DATE to ISODate (ISO 8601)Permalink
=TEXT(A1,"yyyy-mm-ddThh:MM:ss")
Change timezonePermalink
=MOD(A1+(<Zone Offset>/24),1)
Categories: blog
Updated: February 18, 2022
You May Also Enjoy
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK