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

Perhaps replace request date in your NETWORKDAYS function with =IF(and(mod(request_date,1)>=0.5,mod(request_date, 1)<1),request_date+1,request_date)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi, Pecoflyer

Thanks for the response. I tried the formula with no luck. I have attached a snapshot of the spreadsheet and was hoping you could advise me further.

Do I need a column for time received and responded?

Appreciate any advice!

Lynn :-)

Attached Files

Test Network Days.xls (25.0 KB, 11 views)