Results 1 to 3 of 3

Calculate time in hours between problem raised and fixed where multiple criteria are true

Threaded View

jacarutu Calculate time in hours... 05-30-2012, 11:10 AM
jacarutu Re: Calculate time in hours... 06-06-2012, 07:08 AM
jacarutu Re: Calculate time in hours... 06-06-2012, 07:12 AM
  1. #1
    Registered User
    Join Date
    02-18-2010
    Location
    Telford, england
    MS-Off Ver
    Excel 2007
    Posts
    13

    Calculate time in hours between problem raised and fixed where multiple criteria are true

    Hi all,

    I have attached some mocked up data to help illustrate the problem.

    B:B must be the same Cust_Id
    C:C must be the same Prob_Desc
    D:D must be 'BLANK'
    E:E must be 'NOT BLANK'
    When all above are TRUE Calculate hours between Problem being logged and finished.

    Constraints;
    Same Cust_Id may appear again with different Prob_Desc.
    Same Prob_Desc may appear with different Cust_Id.
    Same Cust_Id may appear again in the future with the same Prob_Desc.

    Can't get my head around it. I can get bits of it to work, but never at the same time.

    Mike
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1