Das Notes Forum

Lotus Notes / Domino Sonstiges => Projekt Bereich => Help-Desk Applikation !!Help!! => Thema gestartet von: alecrespi am 07.03.07 - 10:26:19

Titel: Statistics By Date Minutes (VIEW)
Beitrag von: alecrespi am 07.03.07 - 10:26:19

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

Titel: Re: Statistics By Date Minutes (VIEW)
Beitrag von: Thomas Schulte am 07.03.07 - 10:57:07

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)

Titel: Re: Statistics By Date Minutes (VIEW)
Beitrag von: alecrespi am 08.03.07 - 09:34:29

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

thank you very much.
you are GREAT
 8)