Hi I'm trying to Count Release Date and Release Shift Based on Time of Sampling Release Date will be 27 hours after the time of Sampling Shift to be decided by time boundaries (If time is between 0800 and 1600, shift A, 1600 to 2400 Shift B, 0000 to 0800 Shift C.) If after 27 hours Sunday has come, release at 1100 hours shift A on next working day(E.g Monday) anyone help me with Formula for Date of release and Shift of Release? For Screenshot https://filestore.community.support.microsoft.com/api/images/28ac4999-22f4-47ea-a65d-b31c7ebd1f50?upload=true

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Calculate Dates and Shift

Thread starter MHA535
Start date May 1, 2018
Tags

excel & formula excel & ilogic release shift time

MHA535

New Member

May 1, 2018

[FONT=&quot]Hi[/FONT]
[FONT=&quot]I'm trying to Count Release Date and Release Shift Based on Time of Sampling[/FONT]
[FONT=&quot]Release Date will be 27 hours after the time of Sampling[/FONT]
[FONT=&quot]Shift to be decided by time boundaries (If time is between 0800 and 1600, shift A, 1600 to 2400 Shift B, 0000 to 0800 Shift C.)
[/FONT]
[FONT=&quot]If after 27 hours Sunday has come, release at 1100 hours shift A on next working day(E.g Monday)[/FONT]
[FONT=&quot]anyone help me with Formula for Date of release and Shift of Release?

For Screenshot https://filestore.community.support...c4999-22f4-47ea-a65d-b31c7ebd1f50?upload=true[/FONT]