0
Undo
Votes
There are 3 shifts, Every shift needs change duty after a Week (Sunday) of the month through 24:00 hrs. as given below detail.
Date: Friday,01/12/2017
Shift:A 00:00 TO 08:00 hrs (Night-duty)
Shift:B 08:00 TO 16:00 hrs (Morning-duty)
Shift:C 16:00 TO 24:00 hrs (Evening-duty)
Date: Saturday,02/12/2017
Shift:A 00:00 TO 08:00 hrs (Night-duty)
Shift:B 08:00 TO 16:00 hrs (Morning-duty)
Shift:C 16:00 TO 24:00 hrs (Evening-duty)
Date: Sunday,03/12/2017
Shift:A 00:00 TO 08:00 hrs (Night-duty)
Shift:B 08:00 TO 16:00 hrs (Morning-duty)
Shift:C 16:00 TO 24:00 hrs (Evening-duty)
Date: Monday,04/12/2017 (Duty Shift would be Changed)
Shift:A 16:00 TO 24:00 hrs (Evening-duty)
Shift:B 00:00 TO 08:00 hrs (Night-duty)
Shift:C 08:00 TO 16:00 hrs (Morning-duty)
Please help me that how to set formula in excel that will show me Shifts: A, B or C will perform their duties on given date in 24:00 hrs.
May kindly please be helped me in this case. in advance I shall be very thankful for him/her.
Thanks & Regards:
Nadeem Sarwar
Date: Friday,01/12/2017
Shift:A 00:00 TO 08:00 hrs (Night-duty)
Shift:B 08:00 TO 16:00 hrs (Morning-duty)
Shift:C 16:00 TO 24:00 hrs (Evening-duty)
Date: Saturday,02/12/2017
Shift:A 00:00 TO 08:00 hrs (Night-duty)
Shift:B 08:00 TO 16:00 hrs (Morning-duty)
Shift:C 16:00 TO 24:00 hrs (Evening-duty)
Date: Sunday,03/12/2017
Shift:A 00:00 TO 08:00 hrs (Night-duty)
Shift:B 08:00 TO 16:00 hrs (Morning-duty)
Shift:C 16:00 TO 24:00 hrs (Evening-duty)
Date: Monday,04/12/2017 (Duty Shift would be Changed)
Shift:A 16:00 TO 24:00 hrs (Evening-duty)
Shift:B 00:00 TO 08:00 hrs (Night-duty)
Shift:C 08:00 TO 16:00 hrs (Morning-duty)
Please help me that how to set formula in excel that will show me Shifts: A, B or C will perform their duties on given date in 24:00 hrs.
May kindly please be helped me in this case. in advance I shall be very thankful for him/her.
Thanks & Regards:
Nadeem Sarwar
There are no replies made for this post yet.