NETWORK DAYS and TIME calculation help

[Dan_B]

Hi

I am trying to use NETWORKDAYS to calculate whether 2 dates and times (4 cells) are more than 6 hours apart from one another but my formula shows everything as FAILED

I've attached the worksheet and below the explanation of how the formula needs to work

The SLA for urgent codes is 6HTAT (6 Hour Turn Around Time), however the shift pattern is 4.45am – 2.30am so if we receive a request between the times of 2.30 am – 4.45am (non operational hours) – then the 6H TAT should NOT start until 4.45am

Very confusing I know any help would be much appreciated

Thanks

Dan_B

[Ace_XL]

Not sure why you need NETWORKDAYS. Use

=IF(C2+D2-(A2+IF(AND(B2>=TIME(2,30,0),B2<=TIME(4,45,0)),TIME(4,45,0),B2))<=6/24,"Met TAT","Not Met TAT")

[Dan_B]

Hi Ace_XL

Will this formula take into consideration working days as the weekends are not included in the calculation of the turn around time

Thanks

Dan_B