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

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

book

Article ID: 57052

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM) CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

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.

Environment

Release: Any
Component: CAUIM

Resolution

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.