Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

8 Hour shift pattern problem

Hi All,

Hope you can help, We have a production facility that operates in 8 hour shift patters (6am to 2pm, 2pm to 10pm, 10pm to 6am). We have a stock report that holds data which is simply Date, Time, Product, Operative
.

We currently run the reports but it's difficult to do the night shift 10pm to 6am, do you have any suggestions on how we can achieve this? Basically we need to see by day by shift

Any suggestions will be helpful.

Thanks

replied

Change the formula above to:

if ({Start_Time}= Time(22,00,00) and {End_Time} = Time(05,59,59)) Then

{Date_field}-1

Else

{Date_Field}

Or, if there are no start and end times that reflect the shift the record belong to, only time of operation, then

if ({Time} >= Time(22,00,00) and {Time} <= Time(05,59,59)) Then

{Date_field}-1

Else

{Date_Field}

Message was edited by: Ido Millet

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question