A somewhat complex (to me at least) Nested IF issue
 

Hi everyone,

I'm working on a report that looks like this

E F G
H I
Request Date Request Time Dispatch Date Dispatch Time
Delay
6
7
8
9
10

The column headings I guess are self explanatory. The problem is with the
Delay column. The formula works somewhat like this. If the Request Time is
before 3:30 PM on a day the item should be dispatched on the same day. If it
is after 3:30 PM, then the dispatch should be done by 11:00 AM the next
working day. We don't work on saturdays and sundays. The delay needs to be
calculated in days.

Can someone please help me out here?