less than 1 minute read

Introduction

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

=TEXT(A1,"YYYY-MM-DDTHH:MM:SS")

Convert from ISODate (ISO 8601) to DATE

=DATEVALUE(MID(A1,1,10))+TIMEVALUE(MID(A1,12,8))

Convert from DATE to ISODate (ISO 8601)

=TEXT(A1,"yyyy-mm-ddThh:MM:ss")

Change timezone

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

You May Also Enjoy

PowerShell Cheat Sheet

1 minute read

Introduction Script blocks i find myself using in powershell all the time

Negative Decimal DWORD to Human Format

15 minute read

Introduction This blog aims to ELI5, how negative numbers are stored in the Windows Registry, or any other DWORD for that matter. Why you may ask? Well, some...