Lotus Notes / Domino Sonstiges > Help-Desk Applikation !!Help!!

Statistics By Date Minutes (VIEW)

(1/1)

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)

--- Ende Code ---

alecrespi:
that's incredible!
it suits perfectly my needs
 ;D

thank you very much.
you are GREAT
 8)

Navigation

[0] Themen-Index