maybe a VBA can solve this?

**blens1** · 02-01-2014, 09:42 PM

I am trying to subtract two times from each other using the formula below. I do not want to count Saturday or Sunday and I have found a formula that works perfect when an item arrives Monday thru Friday. But, when the item arrives on Saturday at 5am and is finished processing on Monday at 5pm it says 1 day and 12 hours and when the item arrives on Saturday at 5pm it says 1 day. When the item arrives on the weekend count should stop.

E13 is start day/time
M13 is end day/Time
F13 is start shift time
N13 is end shift time

=IF(AND(INT(E13)=INT(M13),NOT(ISNA(MATCH(INT(E13),
HolidayList,0)))),"0 days 0 hours", IF(INT(E13)=INT(M13),
"0 days " & ROUND(24*(M13-E13),2)&"hours",
MAX(NETWORKDAYS(E13+1,M13-1,HolidayList),0)+
INT(24*(((M13-INT(M13))-(E13-INT(E13)))+
(N13-F13))/(24*(N13-F13)))&
" days "&MOD(ROUND(((24*(M13-INT(M13)))-24*F13)+
(24*N13-(24*(E13-INT(E13)))),2),
ROUND((24*(N13-F13)),2))&" hours "))

**alansidman** · 02-01-2014, 09:51 PM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

**FDibbins** · 02-01-2014, 09:51 PM

Edit: Alan beat me to it

**FDibbins** · 02-01-2014, 09:52 PM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

http://www.excelforum.com/excel-form...lp-needed.html