Difference in time HOURS/MINS betwn 2 dates excluding Holidays,Leaves,WkOffs+Overtime

Dear Forum,

I am picking a cue from the recent post on Time DIfference Between 2 Dates..

http://www.excelforum.com/excel-work...-weekends.html

Difference in time HOURS/MINS betwn 2 dates excluding Lunch Tea Breaks, Holidays,Leaves,WkOffs but including Overtime

It was a sheer coincidence that I was looking for something similar for calculating the time in Hours or Mins (Billable Hours) for people involved in data entry work.

Just some things additional are as follows:

Lunch & Tea Breaks and Overtime over and above the the regular shift-timing..

The Start Date, Closing Date and Start Time and Closing Time as well as Overtime Rates is a new addition...

Regards
e4excel