HI all
Statistics Report ticket age display i think unix time stamp. how to convert all display windows time stamp???
Ticket Age in Statistics Report
Moderator: crythias
-
kalyana1315
- Znuny expert
- Posts: 171
- Joined: 24 Apr 2013, 12:29
- Znuny Version: OTRS3.3
- Real Name: kalyanachakravarthy M P
- Company: TATA Technologies
- Location: Pune,India
- Contact:
-
kalyana1315
- Znuny expert
- Posts: 171
- Joined: 24 Apr 2013, 12:29
- Znuny Version: OTRS3.3
- Real Name: kalyanachakravarthy M P
- Company: TATA Technologies
- Location: Pune,India
- Contact:
Re: Ticket Age in Statistics Report
kalyana1315 wrote:HI all
Statistics Report ticket age display i think unix time stamp. how to convert all display windows time stamp???
csv or Excel Time is
=(UnixTime + ("1/1/1970"-"1/1/1900"+1)*86400) / 86400