Unix2UTC and UTC2Unix

Here are a couple of quick calculations to convert Unix time to UTC time and vice versa. Unix2UTC Unix2UTC = VAR UnixDays = MAX([UnixTime])/(60*60*24) RETURN (DATEVALUE("1/1/1970")+UnixDay...

Unix2UTC.pbix493 KB

Mathematical

Other

Time Intelligence

schnarf78

Frequent Visitor

4 years ago

Thank you Greg_Deckler . The first calculation worked for me, although I had to remove the MAX formula, and first had to extract the numbers from the /Date(, but otherwise perfect!