T
The Narcissist
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?
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?