ellyzadg
Board Regular
- Joined
- May 9, 2016
- Messages
- 75
Hi Everyone,
Would like to seek for your help on how can I get minute difference between two dates considering working days and working hours
Working days - Monday to Friday
Working Hours - 8AM - 6PM
Sample Scenario
<tbody>
</tbody>
<tbody>
</tbody>
Thank you in advance!![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Would like to seek for your help on how can I get minute difference between two dates considering working days and working hours
Working days - Monday to Friday
Working Hours - 8AM - 6PM
Sample Scenario
Start Date | Finished Date | Desired Result in minutes |
2/14/2018 6:30:00 PM | 2/14/2018 8:45:00 AM | 45 mins |
2/15/2018 6:00:00 PM | 2/18/2018 8:30:00 AM | 30 mins |
<tbody>
</tbody>
<tbody>
</tbody>
Thank you in advance!