Date-Time Shifts Trouble

[ieuyar]

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:

Machine	Date	Shift	Working Time(min)	Stoppage (min)	Net Working Time
AAA	12.02.2018	00-08	480	180	300
AAA	12.02.2018	08-16	480	480	0
AAA	12.02.2018	16-24	480	480	0
AAA	13.02.2018	00-08	480	40	440

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

Thanks,

[Gysbert_Wassenaar]

Perhaps this discussion helps: Task/Ticket Duration

Or this one: Calculate hours between two Date/Time strings‌

Or Expression with Working Days and working Hours

[ieuyar]

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

Calculate hours between two Date/Time strings