Thread: Times
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sed sed is offline
external usenet poster
 
Posts: 24
Default Times

Call ID Status Type Assigned Resolved Database ID Name
754776 Closed Problem 05/22/08 05/22/08 dschnabe MFGSYS
751502 Closed Problem 05/09/08 05/09/08 dschnabe SAP_MFG
747345 Closed Problem 04/21/08 04/21/08 dschnabe MFGSYS
746533 Closed Problem 04/16/08 04/18/08 dschnabe MFGSYS
746472 Closed Problem 04/16/08 04/17/08 dschnabe SAP_MFG
745730 Closed Problem 04/14/08 04/15/08 dschnabe MFGSYS
741597 Closed Problem 03/26/08 03/27/08 dschnabe SAP_MFG
738441 Closed Problem 03/12/08 03/18/08 dschnabe SAP_MFG
738424 Closed Problem 03/12/08 03/13/08 dschnabe SAP_MFG
737777 Closed Problem 03/10/08 03/11/08 dschnabe MFGSYS
737773 Closed Problem 03/10/08 03/11/08 dschnabe MFGSYS
737271 Closed Problem 03/07/08 03/10/08 dschnabe MFGSYS
737253 Closed Problem 03/07/08 03/07/08 dschnabe MFGSYS
755669 Closed Problem 05/27/08 05/28/08 dschnabe MFGSYS

How can I determine if user DSCHNABE has more than 5 CALLID's in the same
period of time? ex. if he has 7 call id's open on 03/27/08 then "Max
Adherence Problem"