I am creating a turn around time report for EKGs in the Emergency Department. I am needing the first EKG only. I need to calculate and average the times for the this first EKG for a person who has chest pain. I have grouped the patients by Account # and sorted by the 3 times. I have supressed the duplicates in various different ways but the average turn around time that I need is including the times that I suppressed. Is there a way to calculate the average without the suppressed times?
Adm Time Acount# Name Order Time Order Completed
11/10 07:45 309456 Doe, John 07:50 07:55
11/10 07:55 309459 Smith, Anita 08:00 08:10
11/10 07:55 309459 Smith, Anita 08:20 08:30
11/10 07:57 309510 Johnson, Jimmy 08:30 08:30
IP Logged
