Hi all,
I am calculating the time interval but excluding a specific non-service hour. In my example:
- in cell A with the value "Aug 9 , 2018 10:05PM"
- in cell B with the value "Aug 10, 2018 02:31PM"
- the service hour is 10:00AM to 10:00PM, including Mon-Sun, including Public Holidays (so I need to exclude the calculation of 10:00PM to 10:00AM)
The result of the formula should show 331 minutes.
I've researched for days already but no luck, appreciated if anyone can help
Nic
Bookmarks