Skip to Content
0
Former Member
May 16, 2018 at 07:08 PM

Need formula for Half hour increments

81 Views

Hi - Have a report that works fine for giving me a count every hour. However I would like to make it give me a count of every half hour!

Here are a few lines of the working every hour formula:

NumberVar HH;
StringVar HD;

HH := ToNumber({Trip_History_Reporting.modtime}[1 to 2]);

if HH = 8 then HD := "08:00 - 08:59" else
if HH = 9 then HD := "09:00 - 09:59" else
if HH = 10 then HD := "10:00 - 10:59" else
if HH = 11 then HD := "11:00 - 11:59" else

HD := "23:00 - 23:59"