Time column not defined

Hi,

I have a data base that logs the water meter. Every 30 seconds the database will get a new value of the water meter. Now I want to get the daily consumed water. I managed to do that with the following query:

The problem I have is that the time column starts at 8:00 pm. It measures the consumption from 8 pm to 8pm the next day. I Would like to set it so it measure from 0:00 to 23:59.

Can somebody help me?

you have to set the time range