ExcelNewbie2020
Active Member
- Joined
- Dec 3, 2020
- Messages
- 322
- Office Version
- 365
- Platform
- Windows
Find the difference in minutes excluding the weekends and out of working time
example, ticket was created Friday at 7:50 pm and was completed Monday at 8:20.
Work starts at 8am and ends at 8pm
The result should be 30min (10 min from 7:50pm and 20min to 8:20am
example, ticket was created Friday at 7:50 pm and was completed Monday at 8:20.
Work starts at 8am and ends at 8pm
The result should be 30min (10 min from 7:50pm and 20min to 8:20am