Age edit format in stat report and stop age HOW???

ayt · Post by **ayt** » 20 Jul 2011, 09:53

format age and stop age this is a big problem
in stat report ( pdf , csv ,.....)

Please how fix that

ayt · Post by **ayt** » 20 Jul 2011, 17:49

please answer me

jojo · Post by **jojo** » 20 Jul 2011, 17:57

Thats not possible

Post by **crythias** » 20 Jul 2011, 19:49

Excel formula (G is closed -- you might use F (changed) or Now() -- E is created )

=INT(G3-E3) & "days" & HOUR(G3-E3) & "hours" & MINUTE(G3-E3) &"minutes"

Your columns may be different based upon export.
Age is

=INT(C3/(24*3600)) & "Days " & HOUR(C3/(24*3600)) & "Hours" & MINUTE(C3/(24*3600)) & "Minutes"

ayt · Post by **ayt** » 21 Jul 2011, 08:48

how is that and where write this code in excel

and about pdf report and stop age

Post by **crythias** » 21 Jul 2011, 18:22

ayt wrote:how is that and where write this code in excel

in a cell when you open the csv file in excel, just adjust the column names to match...

ayt wrote:and about pdf report and stop age

Jojo already told you: you can't. Age is how old the ticket is: Now minus create time.

ayt · Post by **ayt** » 23 Jul 2011, 23:56

But the age of the ticket, either ( excel , pdf ) not stop

Is not logical to close after the ticket does not stop age

There is no solution

Znuny Open Source Ticketsystem