Excel Calculation Question

Hello,
I have a time sheet spreadsheet in which I keep time in minutes and hrs spent on work orders.
I have log in and log out times, two break times and lunch. I can only count time not accounting for lunch or breaks. So for ex. an employee works 7:00am - 1:30pm and takes break 9:00am-9:30 and lunch 12:00-12:30 I need to deduct the 10 minutes and 30 minutes for braek and lunch, if the time falls within these range. How do I go about it?

Thanks in advance!

 

So if the clock in time is less than 9:30 and the clock out is greater than 9:40 you deduct 10 minutes.
if the clock in time is less than 12:00and the clock out is greater than 12:30 you deduct 30 minutes.
if the clock in time is less than 2:30 and the clock out is greater than 2:40 you deduct 10 minutes.
You could Google it, like this one, You could also ask Reddit's Excel group (they don't like doing your homework, but some help), you could try Fiverr, but they usually want a lot more to write your VBA code, or grab a book like I did. I'm no VBA guru, I just figured out 'my' issue.

Links in text above.