Ok, so I added a few more lines of data. What I need is three different identifiers. We would like to know jobs that take 0-8 hours to run, 8-16 hours to run, or 16-24 hours to run. So, each line of data should be identified as one of those three timeframes.
Once I have the identifiers I can either do a sum or count in my pivot table.
Thank you again. I appreciate your help with this.
|