Hi all,
I am using a Network Days formula to return Turn Around time (formula posted below). The issue is that often, we will have people working on a Saturday to complete work, so when that happens, I get a negative return. Ideally, I would like to count these Saturdays they work, but for the Saturdays they do not work, I want the clock to stop (so to speak) and not count the time on Saturdays. If this is possible, let me know....however, if not, then I would like a formula revision to the one below that will not include negative numbers. Thank you
O = From Received Time (start date)
P = To Received Time (end date)
=NETWORKDAYS(O2,P2,'TimeSheet Data'!$B$376:$B$385)-IF(NETWORKDAYS(O2,O2,'TimeSheet Data'!$B$376:$B$385)=0,1,MOD(O2,1))-IF(NETWORKDAYS(P2,P2,'TimeSheet Data'!$B$376:$B$385)=0,0,(1-MOD(P2,1)))
Thanks in advance!!!!
Bookmarks