You will need to create your own grouping formula.
For the purpose of this discussion the formula name is for example if hour({DATE-TIME}) in [1,4] then 1 else if hour({DATE-TIME}) in [5,8] then 2 else if hour({DATE-TIME}) in [9,12] then 3 else if hour({DATE-TIME}) in [13,17] then 4 else if hour({DATE-TIME}) in [18,21] then 5 else if hour({DATE-TIME}) in [22,00] then 6 you then group off this formula. Your group names will be 1, 2, 3, 4, 5, 6 if you want those names to be more meaningfull then write a second formula. For the purpose of this discussion the formula name is if = 1 then "00:00 to 04:00" else
if = 2 then "05:00 to 08:00" else (etc....)
you can then change the group, and select options, select use a formula as group name, then select the formula 4hourname
Add a comment