Formulat calculating late arrivals...
I have a spreadsheet of late deliveries. There are several delivery due times.
I need to have a formula the shows in Hours and Minutes how long after the due time the delivery was made.
However the following applys
there are 2 different working hours
07:00 - 08:00
08:00 - 18:00
Some items are for a Mon - Fri Delivery, some are Collect Saturday - Deliver Monday, some are Collect Friday, Deliver Saturday.
I may not seem clear
I cant see where I can attach the spreadsheet on here so please let me know and I can email it
Thanks
Bookmarks