Automatically deduct breaks from total time worked?

[DC81]

Hi folks.

I’m working on a Job Record app that (in it’s simplest form) will log:

• Date
• Employee Name
• Job Name
• Job Type
• Start Time
• Finish Time
• Total Hours

My question is, start and finish times vary, so how would I make it automatically deduct if it should cross over:

• Morning tea - 15mins (10:30-10:45)
• Lunch - 1hr (12:30-1:30)
• Afternoon Tea - 15mins (3:30-3:45)

For example, some jobs might start at 8:30 and finish at 10:00. No deduction…
Others might start at 9:00 and finish at 11:30 and there we have a deduction for morning tea.

What if I start a job just after morning tea and finish it at 5:30pm? That should automatically deduct Lunch (1hr) and Afternoon Tea (15mins). See what I mean?

Do I need to set multiple triggers for each break start and finish? That’s at least 12 triggers and would be a lot of messing around. Something easier maybe?

Thanks in advance, my head is sore thinking about it!!!

DAN