Sum Start & End Time, But Deduct Breaks If The Start & End Time Falls During Break Times

Hello Experts
I have created a production report
Now the operator will fill in the job start and end times. In a day they could start and finish multiple jobs

Is it possible for Excel to sum the start and end time, but if the start and end times fall during scheduled break times. It should deduct the break times and give a total minus the break

I have attached a copy of my excel sheet and screen capture

Thanks and kind regards
Rahul

Hi Joris
Thanks for the solution and it works as i had wanted
But i have come across another problem which i hadn't thought of when I asked the question

If someone works from 06:30am till 12:00pm going home early and having only the morning tea break
The formula throws up a #NUM error because the Lunch & afternoon tea breaks columns are blank

Is there a way to ignore if blank?

Thanks and regards
Rahul

Rahul,

i assumed the times mentioned in the Time section being the daily schedule and they would not change.
Changed the formula so it handle's the blanks. Be aware to make the formula work both time fields from a break should be blank.