Pivot grouping Hours limited to 24 hours?

[indygo]

Hi,

I've calculated difference between dates in hours - so if it was 2 days it will show 48 hours and so on, but pivot table grouping doesn't allow me to set group above 24h limit...

Any ideas how to remove this limit? Otherwise I will have brackets from 0 to 23...

 

[FormR]

I've calculated difference between dates in hours

Hi, what is that calculation?

If you make it (biggerdate-smallerdate)*24 and format the cells as general or number can you not choose a custom grouping?

 

[indygo]

I did =ABS(c1-d1) and formatted them to [HH] only so if difference was 30 minutes it will show as 00.
01:10:00 will show as 01 and so on.

 

[FormR]

I did =ABS(c1-d1) and formatted them to [HH] only so if difference was 30 minutes it will show as 00.
01:10:00 will show as 01 and so on.

OK - maybe you could try =INT(ABS(c1-d1)*24) instead with the cells formatted as general.

 

[indygo]

Perfect! Works great.

Thank you