Hi
I'm back!
I managed to get a colleague's spreadsheet working with the examples provided above which is great. So I thought I would try and use something similar for my own requirements which are slightly different e.g. different tasks and different targets.
I have attached my spreadsheet here and need a formula that will work out the cells from AJ to AR but have had no luck trying to tweak the 3 examples kindly provided for my needs.
Also, if something is received after 12 noon, I don't want that day counted in the number of working days.
I have also broken my master tab up into separate tables, blue is for logging mail, orange is for the completion of task and green is for document type. Is this the problem cos I'm not precious about keeping the sections as a table. I'd be happy with one big table!
I hope this all makes sense.
Can you help?
Lynn
Last edited by LynnMac2016; 06-13-2018 at 08:33 AM.
Reason: Spelling errors
|