MySql Query help

["Paul Smith" <ukha@xxxxxxxxxxxxx>]

Hi Guys,



I've been dumping meter readings into a simple mysql
database. Basically every minute the number of flashes the meter makes
is recorded, along with the date-time of the entry.



A while back I had some help getting out hourly and daily totals which I
use to create my live charts. However it dawned on me last night that if
I know the time at which the cheap rate switches in I then already have
the data in the date base.



So what I am looking to do is sum up the minute readings between 00:30
and 07:30 and call that Cheap and then the rest as Normal. In the past I
have only had to sum up one total which makes life very easy to do hours
or days or month or years, but with this added requirement I am getting
very confused.



Any one care to point me in the right direction.





Regards,





Paul



[Non-text portions of this message have been removed]