Total Time Less Lunch Overlap

[Legacy 436357]

Hello is there a way to adjust the formulas in Column I so that if the times overlap the lunch break (12 pm to 12:30 pm) it deducts that time?

I have the Lunch In L12 and Lunch Out L13 if that matters.

So it should be a 30 minute break.

The result of the new formula would then be I5 2.5 hours.

Thank you

Excel Workbook
	G	H	I
3	Start Time	End Time	Task Time
4	8:00 AM	10:00 AM	2:00
5	10:00 AM	1:00 PM	3:00
Week 27

 

[Aryatect]

Hi,

Cell I4 be =IF($H4<>"",IF(AND($G4<=$L$11,$H4>=$L$12),$H4-$G4+$L$11-$L$12,$H4-$G4),"")

 

[Legacy 436357]

Thank you again but I had to adjust the cells that contained the Lunch In and Lunch Out.

I do appreciate the help.