I am currently working with a client that would like to find out the how much time an employee spends on a call. I created a dictionary field that calculates time spent but, it doesn't work if your hours go into the following day (24/7).

Here is the formula that I used:

IF {TIMECLR} ] 86340 THEN TIMECLR =INT({TIMECLR} + 86340

@ANS={TIMECLR}-{TIMEARR}

The field timeclr is the time the employee cleared the call. The field timarr is the time the employee arrived on the call.

My Rlist looks like this: List (filename) timearr timeclr total time.spent.

Provided the difference isn't greater than a day, try this:

CLR={TIMECLR}

ARR={TIMEARR}

IF ARR<CLR THEN

@ANS=(86400-CLR)+ARR

END ELSE @ANS=ARR-CLR

Using @ANS inbetween DICT references will mess it up.

This should get you close.

Charles Schmidling

DATASCAN SYSTEMS, Inc.

cbms (at) Belnet (dot) Com

You got it write, almost. You're reloading the TIMECLR variable by having it in braces both times.

Try

TimeClr={TIMECLR}

IF TimeClr ] 86340 THEN TIMECLR =INT(TimeClr + 86340)

@ANS=TimeClr-{TIMEARR}

apk@sprezzatura.com

Sprezzatura, Inc.

Thank you Arron your solution worked. I also appreciate your response Charles.

View this thread on the forum...