Statistics By Date Minutes (VIEW)

[alecrespi]

In the view mentioned above I can see 2 different column with 2 differen formulas:

1) TIME OF FIRST RESPONSE
_intTimeMinutes := @Integer(@Modulo((@TextToTime(openedByIT)- @TextToTime(dspDateCreated));3600)/60);
_intTimeHours := @Integer((@TextToTime(openedByIT)- @TextToTime(dspDateCreated))/3600);
@Text(_intTimeHours) + ":" + @Right("00" + @Text(_intTimeMinutes);2)

2) TIME OF TICKET COMPLETION
_intTimeMinutes := @Integer(@Modulo((@TextToTime(DateCompleted)- @TextToTime(dspDateCreated));3600)/60);
_intTimeHours := @Integer((@TextToTime(DateCompleted)- @TextToTime(dspDateCreated))/3600);
@Text(_intTimeHours) + ":" + @Right("00" + @Text(_intTimeMinutes);2)

Is there a way to count the difference (in format "hh.mm") between these two column or value?
Thank you

[Thomas Schulte]

Build a new column and insert the following formula:

Code

_intTimeMinutes := @Integer(@Modulo((@TextToTime(DateCompleted)- @TextToTime(openedByIT));3600)/60);
_intTimeHours := @Integer((@TextToTime(DateCompleted)- @TextToTime(openedByIT))/3600);
@Text(_intTimeHours) + ":" + @Right("00" + @Text(_intTimeMinutes);2)

[alecrespi]

that's incredible!
it suits perfectly my needs
 

thank you very much.
you are GREAT