I have a crystal report that has dates in it and I need to know the time difference as the status changes from In Progress to Completed. Don't care about any other statuses, but they are currently built into the report so disregard them.
I am attaching the report.
For each account, as the status (line 2,5) changes from In Progress to Complete, I need to show the time difference in hours and minutes across from the account #. When there are more than one In Progress times, I only want to use the first In Progress time, none of the others.
I also want to disregard any accounts that are do not have both an In Progress and Complete time.
This is over my head.