Basically the normal working hours are:

Mon-Fri 07:00 - 16:00 (including 1hr lunch)
Sat 07:00 - 12:00
Sunday Closed


Could someone please help me with a formula that would not include lunch break but at the same time take in to consideration if someone worked outside the specified working hours. For e.g

Start time Fri 12/10/12 08:00
End time Mon 15/10/12 16:45

Thank you