
i have the above where the first column has the time a certain activity took place. what im wanting to do is group the activity with hours of the time value. So e.g. hour 1 should be everything that happened between 0500-0559, then hours 2 should be everything that happened within 0600-0659 and so on.
im less than an novice in BO and only good at creating basic reports. would be grateful for guidance provided by anyone.