Replies

Great question, and I wish that I had an answer for you. Someone set the rules a long time ago. I only want to find an easier way to calculate this, and alleviate the manual process that it is today

Is there another way that this could be put together so that it would show total processing days for work processed on the weekend. Ex:
Availdate is Thursday

Work processed that Thursday, by shiftID 1 or 3 would count as day 0. Work processed by shiftID 2 would count as day 1.
Work processed on Friday, by shiftID 1 or 3 would count as day 1. Work processed by shiftID2 would count as day 2.
Work processed on Saturday or Sunday, by any shift, would count as day 3.
Work processed on Monday, by shiftID 1 or 3 would count as day 3. Work processed by shiftID 2 would count as day 4.

Am I going about this the wrong way?

Is there another way that this could be put together so that it would show total processing days for work processed on the weekend. Ex:
Availdate is Thursday

Work processed that Thursday, by shiftID 1 or 3 would count as day 0. Work processed by shiftID 2 would count as day 1.
Work processed on Friday, by shiftID 1 or 3 would count as day 1. Work processed by shiftID2 would count as day 2.
Work processed on Saturday or Sunday, by any shift, would count as day 3.
Work processed on Monday, by shiftID 1 or 3 would count as day 3. Work processed by shiftID 2 would count as day 4.

Am I going about this the wrong way?

Hans,

I’m back!!!!

I was wondering if you could assist me again with this TAT formula. Currently, it is adding an extra day for work processed on Sundays (because the shiftID is 2). Can this be changed to only look at shiftID 2 for work processed Monday-Friday? I have also been advised that any work processed on Monday, by any shiftID other than 2 would not increment up by 1 day.

Jumping back to your last reply, the reason that I felt the modified formula worked was because it gave me a running total for Processing Days.

Thanks for looking at this

Marie

Hans,

I’m back!!!!

I was wondering if you could assist me again with this TAT formula. Currently, it is adding an extra day for work processed on Sundays (because the shiftID is 2). Can this be changed to only look at shiftID 2 for work processed Monday-Friday? I have also been advised that any work processed on Monday, by any shiftID other than 2 would not increment up by 1 day.

Jumping back to your last reply, the reason that I felt the modified formula worked was because it gave me a running total for Processing Days.

Thanks for looking at this

Marie

Basically something along the lines of what’s in the attachment. Where the choices in the validation list box in column A are limited to only the values in column C which do not contain blank text.

Basically something along the lines of what’s in the attachment. Where the choices in the validation list box in column A are limited to only the values in column C which do not contain blank text.

You’re right…

I hope to be able to use this formula to work in databases that are utilized in different 2 sites that we operate. One site currently does not work in Saturdays, the other does. Even those things are likely to change. That seems to be the norm these days.

Thanks again so much.

You’re right…

I hope to be able to use this formula to work in databases that are utilized in different 2 sites that we operate. One site currently does not work in Saturdays, the other does. Even those things are likely to change. That seems to be the norm these days.

Thanks again so much.

Hans,

I made a slight modification:

Processing Days: IIf(Weekday([tblRender]![insertdate],2)>6,[tblRender]![insertdate]-[tblReceived]![availdate],[tblRender]![insertdate]-[tblReceived]![availdate]-([shiftID]=2))

This seemed to keep the work processed on Saturday and Sunday at the same number of days.

Thanks again for all of you help! Have a great evening!!!

Marie

Hans,

I made a slight modification:

Processing Days: IIf(Weekday([tblRender]![insertdate],2)>6,[tblRender]![insertdate]-[tblReceived]![availdate],[tblRender]![insertdate]-[tblReceived]![availdate]-([shiftID]=2))

This seemed to keep the work processed on Saturday and Sunday at the same number of days.

Thanks again for all of you help! Have a great evening!!!

Marie

Hans,

I really appreciate your patience with me

The processing days increase on Sunday, but not on Monday. How can that be changed to reflect the opposite?

Hans,

I really appreciate your patience with me

The processing days increase on Sunday, but not on Monday. How can that be changed to reflect the opposite?

Hans,

Thanks again and again for all of your help.

My query seems to be hung up on “vbMonday”. Help!!

Hans,

Thanks again and again for all of your help.

My query seems to be hung up on “vbMonday”. Help!!