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.


Former Member

Change the formula above to:

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




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




Message was edited by: Ido Millet

0 View this answer in context

Helpful Answer

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