Group By 2 Hours

[PhilMyWallet]

Is there anyway I can group my report by every 2 hours. I can do this standard for each hour, however I need to produce a report which has subtotal each 2 hours.

I use v 8.


Cheers


Phil

 

[Madawc]

Try 2*(Truncate(({hour}/2), 0)). 6 and 7 should both become 6, 8 and 9 should both become 8.

Madawc Williams (East Anglia, UK)
Windows XP & Crystal 10

 

[PhilMyWallet]

The group I have is a timestamp by each 15 minute (date / time format).

How do I create a formula using this timestamp when it is for each 15 mins, or do I create the formula based on the group total?


Thanks



Phil

 

[Madawc]

DatePart("h", {your.date}) should do it. Build up the formula by stages, checking that each portion works before adding an outer layer. Then use it to group.

Madawc Williams (East Anglia, UK)
Windows XP & Crystal 10

 

[PhilMyWallet]

Works a treat. Thanks!!!