I am calculating care visits and whether these were early,late or missed.
I have Planned start times and actual start times and need to calculate if the actual start time is more/less than planned by 30m then this will show early/late but then if the actual time is blank then this will show missed
I have Planned start times and actual start times and need to calculate if the actual start time is more/less than planned by 30m then this will show early/late but then if the actual time is blank then this will show missed