Hi

I have received great advice from this forum on a few queries that I have had when creating complex documents and formulae. I'm hoping to utilise that help again.

Scenario

I have a network days formula in my spreadsheet to track Manager requests. I have 2 working days to respond to the request. My formula is set up to calculate the number of working days from the date request was received until the date that I respond (excluding holidays)

I now want to tweak the formula further so that if the Manager request is received after 12 noon that it doesn't count as a working day e.g. request received 2.30pm on 9 May 2016 won't count as a working day until 10 May 2016.

Hope that makes sense!

Any ideas? Any help greatly appreciated.

Lynn