Crystal Report Formula to calculate (early, late, ontime)

[capronton]

Can someone help me write formula to calculate (early, late, ontime)?

If departure time - schedule time > -30 sec then "early"
If departure time - schedule time > 300 sec then "late"
If departure time - schedule time between -30 sec and 300 sec then "ontime"

In other words if bus departs more than half-minute before schedule time "early"
If bus departs more than 5-minutes after schedule time "late"
else bus "ontime"

Can someone help me write syntax for this?

Thanks.

 

[kray4660]

Basically you would need a if then statement using the datediff function, unfortunately I do not have time to work up the formula right now.

 

[briangriffin]

Please test thoroughly.

if datediff("s",{Scheduled},{Departed) < -30 then "Early"
else
if datediff("s",{Scheduled},{Departed}) > 300 then "Late"
else
"On Time

 

[capronton]

Thanks.