/vt/ - Virtual Youtubers

>>13701185
I had something set up in Excel to parse them when we were having "dupe" issues in August, just found it.
it was in the power query I was running on the downloaded/local json
>= Table.AddColumn(#"Filtered Rows", "Time", each #datetime(1969,12,31,20,0,0) + #duration(0,0,0,[Column1.timestamp]/1000))
>= Table.TransformColumnTypes(#"Added Custom",{{"Time", type datetimezone}})
I don't remember how I actually got power query to do that, or how it fuckin works to begin with, but it's operating on the column that contained all the Unix timestamps and spitting out a new EDT one, then displaying it with the right Excel formatting. if you want EST just change it to #datetime(1969,12,31,19,0,0) - note that 19.