|Here is one way of doing it.|
With your data like:
A B C D E F
1) Date Arrive Lunch Out Lunch In Depart Total
2) 09/25/2013 8:00 13:00 13:45 17:00
In cell F2 enter the formula: =(E2-B2)-(D2-C2)
See how that works for you.
Also, please Do Not post in all CAPS, it is the equivalent of shouting and many find it rude.
message edited by mmcconaghy