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))
<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.
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 |
<tbody> </tbody> |
<tbody> </tbody> |
<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 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | 13:00:00 | 15:00:00 | 12:00:00 | ||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | 13:00:00 | 15:00:00 | 12:00:00 | ||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | 13:00:00 | 15:00:00 | 12:00:00 | ||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | 13:00:00 | 15:00:00 | 12:00:00 | ||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<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.