Grouping in a Pivot

[walterdp]

Hi all:

I'm having a difficult time to do this, so... need help!
Basically I have a table full of data. I need to group that data into certain time categories. Let me be clearer:

Each row (around 15000 +) has it's own timestamp and I need to group them like:


Count all that are -4 hours from NOW() (this means they missed SLA)
Count all that are -2 hours from NOW() (this means they missed SLA)
Count all that are +2 hours from NOW() (they will miss SLA in 2 hours)
Count all that are +5 hours from NOW() (they will miss SLA in 5 hours)
Count all that are +10 hours from NOW() (they will miss SLA in 10 hours)
etc

As of now I've created long formulas with countifs but they are taking long time for recalculating every time I make a change of any kind on any cell!

I've tried also with a Pivot Table, and grouping, but it does not work as expected.

Any idea??

 

[walterdp]

Hi all:

Finally I tweaked the formula in the table and I made a manual sorting on the pivot. This has some how resolved the issue.

Thanks to all for the support!!!