NWE agent install time

[YounisKhan]

we are facing problem to generate time formats in excel sheet for NWE agent install time, we have tried all option time format is generate. following are the format, any one can help who to convert in proper date and time in excel sheet.

Agent - InstallTime
1.61469E+12
1.61469E+12
1.61469E+12
1.61488E+12

Thanks

[JoshRandall]

@YounisKhan That's a date in epoch or Unix time (https://en.wikipedia.org/wiki/Unix_time). You need to format the column as a number, not as a date.

[YounisKhan · Accepted solution]

I have tried but not successful. but we found the solution . you need to follow below steps.

1- Insert one additional column Suppose "H"

2- user the formula (=G2/86400000+DATE(1970,1,1)

Note: G is the column for agent install time

3- Now format the new Inserted column "H" as  per your own choice --> I do Like custom one  ( m/d/yyyy h:mm:ss.0 AM/PM )

This work for me fine. Please try and share the experience. I got so many request from management to update how many agent installed on daily or weekly bases.