Employee & Manager Total Time/Days Together in a Work Week

July 4, 2019 at 08:43:39
Specs: Windows 10
I am trying to determine the total hours and days that an employee and a manager will be working together in a work week. B (start time) and C (stop time) of the employee while D is their rest days. F is the rest day of the manager while G (start) and H (stop) of manager. I - How many hours together? J- How many days together?

	A	B	C	D	E	F	G	H	I	J
1	Em1	09:30	18:30	Sat/Sun	Mg1	Fri/Sat	15:00	00:00		
2	Em2	09:30	18:30	Sat/Sun	Mg2	Sat/Sun	08:00	17:00		
3	Em3	09:30	18:30	Sat/Sun	Mg3	Sun/Mon	04:00	13:00		

		

message edited by ChGatsby


See More: Employee & Manager Total Time/Days Together in a Work Week

Reply ↓  Report •
Related Solutions


Ask Question