sharepoint2013 the time zone setting of the audit log

The time that the audit log was recently encountered in the project is in GMT format, and how to format it as local time.

Site collection Setting the cost area is not able to resolve this type of problem, and later query the data to know. Cannot change

Change Audit time from GMT time Zone?

Audit entries is stored in GMT, so that's what's in Excel. Looks like you can easily convert it within Excel, though:

Http://www.ehow.com/how_5882129_convert-gmt-time-microsoft-excel.html

The formatted Excel date format is included as follows:

1. Open Exel Add a column: Current time, such as:

2. Increase the calculation formula on this column: = Send Time column + 8/24, such as:

3. Format time:yyyy-mm-dd hh:mm:ss

sharepoint2013 the time zone setting of the audit log