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