jawaharprem
New Member
- Joined
- Apr 6, 2016
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
Hi Team,
Please help this formula,
Need to calculate correct work hours by date & time tat is 2 hours from allocation date and closing date
Ex - 11/9/2021 12:34:06 AM - 11/10/2021 7:34:00 AM work hours should by 1 hours bzc after 1AM shift it closed and Saturday & Sunday should not consider
i using this formula but not getting correct hours.
=IF(A11="","",(NETWORKDAYS(A11,D11)-1-MOD(A11,1)+MOD(D11,1))*24)
Please help on same.
Thanks.
Please help this formula,
Need to calculate correct work hours by date & time tat is 2 hours from allocation date and closing date
Ex - 11/9/2021 12:34:06 AM - 11/10/2021 7:34:00 AM work hours should by 1 hours bzc after 1AM shift it closed and Saturday & Sunday should not consider
i using this formula but not getting correct hours.
=IF(A11="","",(NETWORKDAYS(A11,D11)-1-MOD(A11,1)+MOD(D11,1))*24)
Allocated | ClaSentD | ClaRecD | Closed | ProcessingTime | WaitingTime | FinalTimeTaken |
11/9/2021 10:59 | 11/9/2021 11:01 | 11/9/2021 11:10 | 11/9/2021 13:05 | 2.11 | 0.15 | 1.96 |
11/9/2021 20:09 | 11/9/2021 20:44 | 0.58 | 0.58 | |||
11/9/2021 20:41 | 11/9/2021 20:50 | 11/9/2021 20:57 | 11/9/2021 21:18 | 0.62 | 0.12 | 0.50 |
11/9/2021 0:34 | 11/10/2021 7:34 | 31.00 | 31.00 | |||
11/12/2021 0:47 | 11/15/2021 7:30 | 30.72 | 30.72 |
Please help on same.
Thanks.