Unix Time

From ip tuning
Jump to: navigation, search


Convert Unix Time to Excel

You can convert the UNIX time from a CDR record from Unix Time (single number) to Microsoft's time like this:

 =UnixTime/86400+25569

You can see an excellent coverage on this topic: http://excel.tips.net/Pages/T002051_Converting_UNIX_DateTime_Stamps.html.