Hi,

I need a formaula to find the actual working hour.

For eg:

My working hours are
3 AM - 5:30 PM (Mon - Fri)
5:30 AM - 4:30 PM (Saturday)
7:30 AM - 4:30 PM (Sunday)

I expect, the difference between

Feb 1, 2013 - 5:00 PM (Friday) and Feb 4,2013 - 7 AM (Monday) should display 24:30 mins.

Time spent - 30 mins (fri) + 11 hrs (Sat) + 9 hrs (Sun) + 4 hrs (Mon) => 24:30 hrs.

Please suggest.