Help on shift management

[stoure]

Morning to everyone,
I have some trouble to process the worked time of different workers in a month.
Here you have a sample below :
[TABLE="class: grid, width: 1037, align: center"]
<colgroup><col><col span="13"><col><col><col span="20"><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 11"]Week from 12/01 to 12/03 2016
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 5"]dimanche 27
[/TD]
[TD="colspan: 5"]lundi 28[/TD]
[TD="colspan: 5"]mardi 29[/TD]
[TD="colspan: 5"]mercredi 30[/TD]
[TD="colspan: 5"]jeudi 01[/TD]
[TD="colspan: 5"]vendredi 02[/TD]
[TD="colspan: 5"]samedi 03[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Shift begining
[/TD]
[TD]00[/TD]
[TD]06[/TD]
[TD]13[/TD]
[TD]18[/TD]
[TD]20[/TD]
[TD]00[/TD]
[TD]06[/TD]
[TD]13[/TD]
[TD]18[/TD]
[TD]20[/TD]
[TD]00[/TD]
[TD]06[/TD]
[TD]13[/TD]
[TD]18[/TD]
[TD]20[/TD]
[TD]00[/TD]
[TD]06[/TD]
[TD]13[/TD]
[TD]18[/TD]
[TD]20[/TD]
[TD]00[/TD]
[TD]06[/TD]
[TD]13[/TD]
[TD]18
[/TD]
[TD]20[/TD]
[TD]00[/TD]
[TD]06[/TD]
[TD]13[/TD]
[TD]18[/TD]
[TD]20[/TD]
[TD]00[/TD]
[TD]06[/TD]
[TD]13[/TD]
[TD]18[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Shift end
[/TD]
[TD]06[/TD]
[TD]13[/TD]
[TD]18[/TD]
[TD]20[/TD]
[TD]00[/TD]
[TD]06[/TD]
[TD]13[/TD]
[TD]18[/TD]
[TD]20[/TD]
[TD]00[/TD]
[TD]06[/TD]
[TD]13[/TD]
[TD]18[/TD]
[TD]20[/TD]
[TD]00[/TD]
[TD]06[/TD]
[TD]13[/TD]
[TD]18[/TD]
[TD]20[/TD]
[TD]00[/TD]
[TD]06[/TD]
[TD]13[/TD]
[TD]18[/TD]
[TD]20[/TD]
[TD]00[/TD]
[TD]06[/TD]
[TD]13[/TD]
[TD]18[/TD]
[TD]20[/TD]
[TD]00[/TD]
[TD]06[/TD]
[TD]13[/TD]
[TD]18[/TD]
[TD]20[/TD]
[TD]00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Worker 1
[/TD]
[TD]X
[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Worker 2
[/TD]
[TD] [/TD]
[TD]X[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Worker 3
[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I'd like to process the number of hours worked per worker and per date.
I'd like to take into account night hours(from 21 to 06) and holidays(such as 01/01/2017).

Thanks in advance!

 

[stoure]

Good afternoon jorismoerings ,!

Thousands of thousand of thanks. That's really what I'm looking for. Wowww, it's exciting, I'm so glad.
You're the smartest of the world.



Is it possible to remove directly a worker from the shift if he is on holiday. I mean no cross in front of his name at the given date.
[TABLE="class: grid, width: 300, align: center"]
<tbody>[TR]
[TD]Name[/TD]
[TD]departure[/TD]
[TD]return[/TD]
[/TR]
[TR]
[TD]worker 1[/TD]
[TD="align: right"]02/12/2016[/TD]
[TD="align: right"]15/12/2016[/TD]
[/TR]
[TR]
[TD]worker 2[/TD]
[TD="align: right"]15/11/2016[/TD]
[TD="align: right"]10/12/2016[/TD]
[/TR]
[TR]
[TD]worker 3[/TD]
[TD="align: right"]18/12/2016[/TD]
[TD="align: right"]25/12/2016[/TD]
[/TR]
</tbody>[/TABLE]
Everything is Ok!
I'll be working on it to night so that I'll get a final file......

 

[stoure]

Hi!
A big thanks to Jorismoering,
My problem is solved now.

 

[stoure]

Re: Solved

Thanks Ali!
I understood you.
It is just to do the same every where because it's a good thing to inform people that help you when you're satisfied(problem solved).
Thanks to all of you.

 

[RoryA]

Re: Solved

We don't mark threads solved here. Also, I deleted all the other posts that weren't relevant to the actual problem at hand.

A couple of very important things to note here:

1. Please read the forum rules on cross-posting and follow them in future.
2. While you are at it, please note the rule about taking questions off the forum.

 

[stoure]

Re: Solved

Will comply!

 

[RoryA]

Re: Solved

That's all we ask.

 

[stoure]

I'm sorry in advance if I'm doing wrong.
I'm not sure If I should open a new forum or just re open this one.
I would like to have some details about the sumproduct formulas above..
I'm being on trouble to have my sheets modified..