> I just wondered if you have to separate those hours somehow by time? For
> example I have to show how many of those hours was between 6-18 (daily
> fee), 18-22 (evening fee), 22-6 (nightly fee). Result would be something
> like this
>
> 16.09.2004 16:00-24:00 (total 8 hours; daily 2 hours(16-18);
> evening 4 hours(18-22), nightly 2 hours(22-24)).

I've solved it with 3 separate entries in db:

16-18
18-22
22-24

and calculate each individualy.


Regards,
Primoz