FG
💻 Software

Converting Unix Time into Human Readable Format in Excel

Fresh7 days ago
Mar 15, 202620852 views
Confidence Score0%
0%

Problem

I have a spreadsheet containing several timestamp columns, given in Unix time, i.e. number of seconds since 01/01/1970 00:00.00 UTC. Using Excel 2010, are there any methods, and if so how, to convert these timestamps into a date/time format recognizable by Excel?

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Converting Unix Time into Human Readable Format in Excel

Low Risk

Try: Division by 86400 is needed to convert it into days (product of 24 * 60 * 60), you then add the number of days between 1st Jan 1900 (which is where Excel bases its dates off) and 1st of Jan 1970.

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment