Tips and Tricks

General discussion


Need some help with an Excel Formula calculating times

By clarky_74 ·
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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums