Miuns Non Working Hours

[vmjan02]

I have this problem, here.

Now in a column A I have the End time and in column C in have the start time.

Am bit confused with the non working hours

From Sun to Thu it is 13:00:00 hrs -- Non working hours
On Friday it is 15:00:00 hrs -- Non working hours
On Saturday it is 12:00:00 hrs -- Non working hours

now here an employee can Swipe in on Monday and can swipe out on Thursday
1 Case
1) Its easy to get the total time (A-C).
2) But here need to exclude the non working hrs (Tue and Wed --(13+13))


now here an employee can Swipe in on Sunday and can swipe out on Friday
2 Case
1) Its easy to get the total time (A-C).
2) But here need to exclude the non working hrs (Monday to Thursday --(65:00:00))

INCIDENT CREATION_date

INCIDENT CREATION_day

INCIDENT Creat Start Time

END_date <tbody> </tbody>

END_day <tbody> </tbody>

END_Time <tbody> </tbody>

Actual Non Working Hrs Sun to Thu

Actual Non Working Hrs Friday

Actual Non Working Hrs Saturday

Final Time Excluding Non working Hrs

5

Thursday <tbody> </tbody>

13:11:44 <tbody> </tbody>

5 <tbody> </tbody>

Thursday <tbody> </tbody>

15:44:51 <tbody> </tbody>

13:00:00

15:00:00

12:00:00

1 <tbody> </tbody>

Sunday <tbody> </tbody>

3:44:23 <tbody> </tbody>

1 <tbody> </tbody>

Sunday <tbody> </tbody>

15:17:27 <tbody> </tbody>

13:00:00

15:00:00

12:00:00

1 <tbody> </tbody>

Sunday <tbody> </tbody>

1:33:48 <tbody> </tbody>

1 <tbody> </tbody>

Sunday <tbody> </tbody>

11:23:51 <tbody> </tbody>

13:00:00

15:00:00

12:00:00

1 <tbody> </tbody>

Sunday <tbody> </tbody>

9:13:39 <tbody> </tbody>

6 <tbody> </tbody>

Friday <tbody> </tbody>

13:58:03 <tbody> </tbody>

13:00:00

15:00:00

12:00:00

1 <tbody> </tbody>

Sunday <tbody> </tbody>

0:16:51 <tbody> </tbody>

2 <tbody> </tbody>

Monday <tbody> </tbody>

13:22:19 <tbody> </tbody>

13:00:00

15:00:00

12:00:00

3

Tuesday

11:48:22

7

Saturday

19:09:45

13:00:00

15:00:00

12:00:00

<tbody>
</tbody>

Any Idea or formula as how this can be done, as the start and end can always vary. but final output will be excluding non working hrs.

 

[vmjan02]

any update.