Afternoon all,
I hope that you can help and I apologise if this has already been explained somewhere and I have just missed it.
I need to be able to record the length of time it takes staff to pick up a document after it has been sent in.
On the spreadsheet I have the time job has come in, the time the staff member has picked up the item, however I then need to be able to discount the hours between 16.00 and 08:00 and that is the part I am having trouble with. Especially as on an odd occasion it may take more than one day for the item to be picked up.
Please can someone help with the formulae.
Thank you
Michelle x
Bookmarks