sksanjeev786
Well-known Member
- Joined
- Aug 5, 2020
- Messages
- 883
- Office Version
- 365
- 2016
- Platform
- Windows
Hello Team,
I have an office timing from 9:00A M to 6:00 PM excluding Sat and Sun.
I need a different hour mention in the below sheet. and calculation need between office timeing
I have an office timing from 9:00A M to 6:00 PM excluding Sat and Sun.
I need a different hour mention in the below sheet. and calculation need between office timeing
Due Date | Deliver | Diff hour with in 9:6 PM |
9/4/2020 21:30 | 9/3/2020 11:00 | 7:30 hr |
9/3/2020 9:30 | 9/2/2020 15:30 | 3 hr |
9/2/2020 11:50 | 9/2/2020 10:50 | 1 hr |
9/7/2020 11:00 | 9/4/2020 17:00 | 3 hr |