hour split with date

[#1]

Hi Experts,

My report has some employees working in two different shifts.

shift1 time : 06 - 20

shift2 time : 19 - 13

With Sunny's help in my post hour split (hour split) i was able to split the hours as required.

but my new requirement is that, if i select an employee, date and a shift, it is not overriding the selection if the shift has two days.

for example, Alan McDonald from my sample worked on a 8th july 2017 20:00pm to 9th july 2017 02:00am

so, if i select the employee and 08.07.2017 and the shift, then it should override the date selection as 08.07.2017 and 09.07.2017 and the hour should show as 20, 21, 22, 23 of 08.07.2017 and 00, 01, 02 of 09.07.2017.

Is it possible? i herewith attached my sample qvw.

can someone please help me to fix this?

[#2]

Can someone please help on this...

[effinty2112]

Hi Pr,

          As far as I can see this is the problem. These are the hours that Alan McDonald worked on 8th July according to the data.

Date	Hour
08/07/2017	00
08/07/2017	01
08/07/2017	02
08/07/2017	20
08/07/2017	21
08/07/2017	22
08/07/2017	23

You know that the hours 00,01 & 02 were actually the early hours of 09/07/2017. The problem is trying to figure out if a shift lasted through midnight or if we are actually seeing work from midnight to 2am then a resumption of work at 8pm.

Is there any further data you can get from your source that identifies the beginning of a shift?  Are there any rules you can tell us about when shifts begin?

Regards

Andrew

[#4]

Hi Andrew,

Actually, Alan has to work on the shift2 i.e. 19:00 to 13:00 (19:00 08.07.2017 to 13:00 09.07.2017)

but he didnt work on the full shift. he left early.

but still we should be able to see the hours he worked on 8th and 9th.