timestamper.online

Epoch Converter Excel

Convert epoch (Unix time) to date/time and back in Excel. Copy‑paste formulas for seconds, milliseconds, and timezone adjustments.

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
Tips
Formatting and timezone
  • Format result cells as yyyy-mm-dd hh:mm:ss for clarity.
  • Add/subtract timezone offset in days: e.g., +8 hours → +8/24.
  • Validate input precision (10 digits = seconds; 13 digits = milliseconds).
Related
Excel: Unix → DateGenerate Epoch Time in ExcelOnline ConverterSeconds vs Milliseconds