Is it possible to calculate difference in days between dates that exclude weekends, then calculate 8 hour day by hourly rate eg
start date: 28/06/2012 end date: 25/07/2012. Actual difference in days is 27, but remove the weekends (8 days) = 19 days. The actual duration in hours between start and end dates = 648 but should be between 7.00am - 3.00pm (8 hours). Hourly rate = $5.00.
End result should be: 19 days x 8 hours = 152 hours x $5.00 = $760.00
Datediff to exclude weekends
Posted - 02/05/2013 : 18:03:34
