How to Convert UNIX EPOCH Time Values into Excel/Windows Time Formats

book

Article ID: 57052

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

Epoch / UNIX time is the number of seconds that has elapsed since 1/1/1970. Excel calculates dates by using the number of days that have elapsed since 1/1/1900. Therefore you are able to convert from one to the other by converting from seconds to days, and then adding on the 70 years difference.

The formula :- =(A1/86400)+25569 where A1 contains the UNIX time should convert to Excel date/time. Make sure you format the cell as the required date/time format, custom - dd/mm/yyyy hh:mm:ss

This field is being exported correctly so you will need to add a new column in Excel and use the formula above.

Environment

Release:
Component: CAUIM