Minus time if in a certain range

[DonnaA]

I'm creating a timesheet that tracks time worked on each work order and I need to build a formula that will automatically deduct the 1/2 lunch break if any of those times entered are within the 12:00 pm to 12:30 pm range.
I tried uploading the add on tool so I could upload a Mini-sheet but I can't seem to add it under developer to my add ins. I went in to properties to tell the my system the program was safe but just says it can't open in protected view but my sheet isn't in protected view ?

TIA for any help

 

[6StringJazzer]

This will subtract 1/2 hour if the start time is before 12:00 and the finish time is after 12:30. It does not take into account times that start or end during lunch break.

(How did you populate the values in your screenshot?)

$scratch.xlsm
	A	B	C	D
1	Start	Finish	Time	Time - Breaks
2	8:00 AM	10:00 AM	2.0	2.0
3	9:30 AM	4:30 PM	7.0	6.5
4	2:30 PM	4:30 PM	2.0	2.0
times

Cell Formulas
Range	Formula
C2:C4	C2	=24*(B2-A2)
D2:D4	D2	=24*(B2-A2)-IF(AND(A2<TIMEVALUE("12:00 PM"),B2>TIMEVALUE("12:30 PM")),0.5,0)