Date-Time Shifts Trouble

ieuyar — Thu, 15 Feb 2018 09:43:39 GMT

Hi all,

In my qlikview project of OEE, i'm trying to calculate stopping minutes per machine over dates and shifts.

I divide a day into 3 parts, 00-08, 08-16, 16-24 shifts. So, one shift is 8 hours.

I'm trying to get net working minutes. there may be such data that stopping is 1180 minutes. So, it is bigger than a shift which is 480 minutes.

In the data, it is on 1 row but I should divide it into shifts.

For example assume that stopping time is 12.02.2018 05:00 and stoppage is 1180 minutes.

I show it this way:

Machine	Date	Shift	Working Time(min)	Stoppage (min)	Net Working Time
AAA	12.02.2018	00-08	480	1180	-700

Customer desires to show the same data in this way:

Could you please suggest me a solution how to achieve it?

Thanks,

Re: Date-Time Shifts Trouble

Gysbert_Wassenaar — Thu, 15 Feb 2018 10:09:25 GMT

Perhaps this discussion helps: Task/Ticket Duration

ieuyar — Thu, 15 Feb 2018 11:58:19 GMT

Thanks a lot. I have implemented below solution according to my requirements.