• absolutely reeks of a homework assignment.

    If you can group by half hours, then you're golden. Try something like getting the number of half hours since midnight, and then grouping on that.