elapsed time with condition

[mtsf26]

hi i want to know how to get elapse time with few conditions:

1. everyday at shift 2 the recess time between 18.00-19.00
2. everyday except Friday the recess time 11.30-12.30 and Friday the the recess time 11.30-13.00
3. so the result is the elapse time exclude the recess time
i also have the screenshoot of my problem.

hxxp://i1106.photobucket.com/albums/h367/mtsf26/time.jpg

NB:change hxxp into http

thanks in advance

 

[Matt Rogers]

Hi.

The link doesn't work.
Maybe you mean this?

Excel Workbook
	A	B	C	D	E	F	G	H
1	Day	Start	End	Break1		Break2		Worktime
2	Thursday	10:00	20:00	11:30	12:30	18:00	19:00	08:00
3	Friday	10:00	20:00	11:30	13:00	18:00	19:00	07:30
Sheet

 

[mtsf26]

Hi.

The link doesn't work.
Maybe you mean this?

Excel Workbook
	A	B	C	D	E	F	G	H
1	Day	Start	End	Break1		Break2		Worktime
2	Thursday	10:00	20:00	11:30	12:30	18:00	19:00	08:00
3	Friday	10:00	20:00	11:30	13:00	18:00	19:00	07:30
Sheet

ehmm..it work actually but i use hxxp instead of http.this is the direct link
http://i1106.photobucket.com/albums/h367/mtsf26/time.jpg maybe you can help me

 

[barry houdini]

Crossposted here

 

[mtsf26]

Crossposted here

but if then in the second condition is just for shift 1 then how to solve it?i forgot to mention that in second condition is just for shift 1..

 

[mtsf26]

but if then in the second condition is just for shift 1 then how to solve it?i forgot to mention that in second condition is just for shift 1..

please anyone help me to solve this problem