select sum(col1), cast(max(col2) as date)
from t;

where col2 >= dateadd(hour, -15, cast(getdate() as date)) and
      col2 < dateadd(hour, 21, (cast getdate() as date))