Calculate Business Hours
Content
Hi,
I am in need of your assistance.
I want to create a formula to calculate how long it takes to complete a task within business hours...
My scenario is as follows;
Start date: 04/03/2011 17:00
End date: 07/03/2011 09:30
Business working hour: 0800 – 1800
Business is closed evening and weekends
Based on the above scenario the time taken to complete the task should be 2.30 hours
Thanks in advance
0