Hi, i am after some help. I have a report that returns times of vehicles returning in the format of dd/mm/yyyy hh/mm and a time that they are signed in, in the same format. I need a report that will see if the times are within a certain time range or not but there is a snag…..the working hours are Mon – Fri 08:00 and 09:00 – 12:00 on a Saturday. All vehicles must be returned within two hours of the time … so for example
Vehicle returns at 18:00 on a Friday therefore if it is signed in by 11:00 am on the Saturday then it is withing scope and therefore a pass…if it is signed in any later than this then it is a fail.
If the vehicle is returned on Sunday at 13:00 then it has to be signed in by 10:00 on the Monday
