timestamper.online

Convert Unix Time in Excel

A compact cookbook to handle Unix time in Excel. Paste the formulas and get accurate date/time results.

Epoch → Date (seconds)
excel
A1 contains Unix timestamp in seconds

= A1/86400 + DATE(1970,1,1)
Epoch → Date (milliseconds)
excel
A1 contains Unix timestamp in milliseconds

= A1/1000/86400 + DATE(1970,1,1)
Date/Time → Epoch (seconds)
excel
A1 contains a valid Excel date/time

= (A1 - DATE(1970,1,1)) * 86400
Date/Time → Epoch (milliseconds)
excel
A1 contains a valid Excel date/time

= (A1 - DATE(1970,1,1)) * 86400 * 1000
Formatting & Timezone
  • Format as yyyy-mm-dd hh:mm:ss for clear display.
  • Apply timezone with +H/24 or -H/24 (e.g., +8/24 for UTC+8).
  • Check precision: 10 digits (seconds), 13 digits (milliseconds).
Related
Epoch Converter ExcelExcel: Unix → DateGenerate Epoch Time in ExcelOnline Converter