Hi,
Does anyone knows how to display ticket age only in hours and days format in csv exported files instead of minutes?
I am using OTRS 3.1.3
Thanks in advanced!
View ticket age in hours or days (CSV)
Moderator: crythias
-
crythias
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: View ticket age in hours or days (CSV)
the value exported apparently is an integer. You may post process (Excel) the value using formulas or possibly formats.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
-
pantered
- Znuny newbie
- Posts: 30
- Joined: 24 Apr 2013, 17:49
- Znuny Version: 3.1.3
- Location: Puerto Rico
- Contact:
Re: View ticket age in hours or days (CSV)
crythias indeed, i would have to convert the units values using this formula:the value exported apparently is an integer. You may post process (Excel) the value using formulas or possibly formats.
=CONVERT(number,from_unit,to_unit)
Example: =CONVERT(888,"mn","hr")
Thanks