Converting Unix Epoch Dates in Microsoft Excel

Ok... this is one of the more 'geekier' posts I've written, but I was trying to convert a Unix epoch (the number of seconds from January 1, 1970) to a standard time using Microsoft Excel. I found a solution online, but it didn't work completely for me, so I thought I would add my solution here, mostly so that when I need to use it again, I'll be able to find it!

Searching Google, I had found this site which converted the epoch for me but I kept coming up with the wrong date and time... All the times were about four years in the future. Obviously, that was wrong, which I knew because I converted one of the times using another converter I had. The formula I was using was this:

=((epoch - 25200) / 86400) + 25569

Then I remembered, being on Mac OS, that day 0 is January 1, 1904. When I subtracted the extra four years from the formula, I got the right time. So, on a Mac, the correct formula is this:

=((epoch - 25200) / 86400) + 24106

So, here you go. The next time you are faced with using an epoch time and having to convert it to a standard time, you can use these formulas for whichever OS you are using.


By Edmond on April 3, 2014 at 7:57 pm

Thanks. I was stumped because of that time difference too, being new to the Mac. This saved me!

By pkaxnIncar on May 7, 2020 at 2:53 pm

cialis cialis online generic cialis 20mg - cialis online

By Free viagra sample on May 7, 2020 at 10:12 pm

Loknrd oqktba Viagra overnight delivery Canadian pharmacy viagra legal

By ebppqIncar on May 8, 2020 at 8:14 am

cialis cheap cialis - cialis

By Free viagra on May 8, 2020 at 1:42 pm

Acsnuf hhfmye Free viagra samples Viagra overnight delivery

By nwwtkIncar on May 9, 2020 at 2:22 am

cialis generic cialis buy cialis - cialis

By rmiirIncar on May 10, 2020 at 6:41 pm

cialis cialis cialis online - cialis cialis

By Generic viagra on May 11, 2020 at 4:31 am

Azdbzu aytptr Usa viagra sales Generic viagra online

By Samples of viagra on May 12, 2020 at 2:28 pm

Iawffd riosny viagra buy Viagra mail order usa

By oytziIncar on May 13, 2020 at 10:45 pm

viagra dick where can i buy viagra online viagra porn stepmom gave me viagra as a joke female viagra too much what does walgreens charge for 100 mg viagra viagra 30 day trial viagra viagra commercial women stars viagra and pregnancy - viagra

By Esthergap on May 14, 2020 at 6:20 am

Hefmoc suhkuq Pfizer viagra Buy pfizer viagra

By ivyomIncar on May 14, 2020 at 7:42 am

weight loss diet weight loss shakes lose weight fast sota weight loss weight loss surgery lose weight best weight loss program chrissy metz weight loss weight loss pills that work weight loss tips - best way to lose weight

By gpfaeIncar on May 16, 2020 at 8:13 am

healthy recipes for weight loss weight loss tips weight loss programs weightloss weight loss pills that work fastest way to lose weight medi weight loss celine dion weight loss healthy recipes for weight loss weight loss pills that work - phentermine weight loss

By ycbfgIncar on May 18, 2020 at 6:04 pm

levitra canada levitra 10 mg levitra vardenafil levitra levitra canada online levitra levitra 10mg buy levitra online levitra generic order levitra - cheap levitra

By ihlrrIncar on May 20, 2020 at 11:57 pm

generic levitra online levitra pills levitra coupon levitra 20 levitra for sale order levitra levitra canada levitra 20mg levitra 10mg levitra 20mg - cheap levitra

By erectile dysfunction drugs on May 21, 2020 at 6:06 pm

Zjjlkr fsvkvh best otc ed pills erection pills viagra online

By best ed pills non prescription on May 23, 2020 at 12:26 pm

Vkoffq fnelwk gnc ed pills ed pills for sale

By top erection pills on May 25, 2020 at 9:30 am

Dmifuc qpxnjo ed pills that work ed pills gnc

By male erection pills on May 27, 2020 at 10:05 am

Oqidkn yxvmok erectile dysfunction medicines medicine erectile dysfunction

By ed medications on May 29, 2020 at 10:16 am

Spgcqa mtljcm best place to buy cialis online ed drugs

Leave a Comment