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 :

															Week from 12/01 to 12/03 2016
	dimanche 27	lundi 28	mardi 29	mercredi 30	jeudi 01	vendredi 02	samedi 03
Shift begining	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20
Shift end	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00
Worker 1	X							X				X			X	X							X				X			X	X
Worker 2		X			X	X							X				X			X	X							X				X			X
Worker 3			X				X			X	X							X				X			X	X							X

<colgroup><col><col span="13"><col><col><col span="20"><col></colgroup><tbody>
</tbody>

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.

Name	departure	return
worker 1	02/12/2016	15/12/2016
worker 2	15/11/2016	10/12/2016
worker 3	18/12/2016	25/12/2016

<tbody>
</tbody>

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..