Sunday, August 7, 2016

Convert accountexpires in Active Directory to Human Read format using Excel


=IF(C2>0,C2/(8.64*10^11) - 109205,"")

This formula works for GMT.



If your time zone is GMT+10, subtract 10/24 (with 7-8 decimals) leading to 109204.58333333

If it is GMT-10, Add 10/24 leading to 109205.0.416666666666667.

1 comment:

Ampcus Inc said...

Infrasturcture Management services in usa

Ampcus offering to clients through a specialized team of system administrators and IT industry experts. Our comprehensive, industry-leading portfolio of IMS guarantee high reliability, round-the-clock availability, remote manageability and optimum scalability to the customers.