Calculate per 15 minutes

[Flupke]

I use a formula to calculate sales per half hour. It goes like this:

time(hour({tblTV_Acties.TVAC_Tijdstip}),
(if minute({tblTV_Acties.TVAC_Tijdstip}) < 30 then
0
else
30),0)

Now I would like to calculate per 15 minutes. I tried to modify that formula, but it does not seem to work.

Any ideas on how to calculate sales per 15 minutes?

Many thanks and greetings from Brugge (Bruges - Belgium),

Michel

 

[Madawc]

Please post your formula. The method should work.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

Create a formula like {@minutes}:

if minute({tblTV_Acties.TVAC_Tijdstip}) < 15 then
0 else
if minute({tblTV_Acties.TVAC_Tijdstip}) < 30 then
15 else
if minute({tblTV_Acties.TVAC_Tijdstip}) < 45 then
30 else
45

Then change your grouping formula to:

time(hour({tblTV_Acties.TVAC_Tijdstip}),{@minutes},0)

-LB