I thought I alreayd posted this but don't see it anywhere, so forgive me if
this is duplicated somewhere.
I am looking for a formula to calculate total hours worked, to exclude
lunch, based on the assumption of a 30 min lunch if working 6 hours or more


a b c d e f g h i j k l m n o p
name total start end start end start end start end start end start end start end
Kathy 36:00 15:00 19:00 5:00 13:30 5:00 13:30 5:00 13:30 5:00 13:30
Bob 28:00 15:00 19:00 5:00 13:30 5:00 13:30 5:00 13:30
Thanks in advance for your help