Calculate hours and minutes on escalated tickets

[fizzel1]

CR 7 - I need to find the time in hours and minutes between the time that a ticket was elevated and the time that the ticket was put in status of "WIP", unfortunately not all 2nd level will handle the ticket in the same manner - so the formula gets complicated -
If status = Group assigned then
"Group Assigned"
else if Status = wip t
then wip.time - group assigned.time or if status = Individual assigned then individual.Assigned.time - group Assigned.time

Then format the results to say x hours and x minutes.

 

[kenhamady]

This will be clearer if you separate the problems. First, do you have two time fields in the same record, or do you have one field in two separate records? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/