do a count of all records

This is becoming more of a pain than I originally anticipated.

This is what the data I'm working with looks like:


Ideally, I'd be able to show a total of all of the time used, then a % of ticket times that were under 30 minutes total. The software we are using is, to be frank, TERRIBLE. It's an older version of Track-IT and it does things slowly, if at all. Ideally that field would be in DD:HH:MM but in the event it's a single digit, it doesn't pad the zero.

As always, any help would be appreciated.

I hate to be a bother, this program seems to do things contrary to anything I've used in the past. I also may be completely missing the point.

Is this along the lines of what you were saying?

Global NumberVar Over30;
Global NumberVar Under30;
if left({TASKS.ELAPSETIME},3)="0:0" and tonumber(right({TASKS.ELAPSETIME},2))<30 then Over30 = Over30+1 else Under30 = Under30+1;

I'm going to keep crunching at this, I haven't had to use this program in years, and it's unfortunately showing quite badly. The syntax just isn't up in my head anymore.

Edited by nathanielban - 13 Sep 2010 at 6:43am

Thank you for spelling it out for me, it's been a rough morning. I really appreciate the help.