Time Schedule Hours Worked minus Lunch

[RLPeloquin]

I can figure out how to subtract hours worked but my problem is subtracting lunch from hours worked. So... I'd like for this to happen.
Of course this formula obviously doesn't work
=if(A4="","",if(A5="","",if(A6>5:30 hours then minus 45:00 minutes from Total hours worked
A4 is Start Time
A5 is Stop Time
A6 is Total Hours Worked, - 45:00 if hours are over 5:30
Thanks in ADVANCE!

 

[etaf]

how about
=IF(OR(A4="",A5=""),"",IF((A5-A4)>5.5/24,(A5-A4)-TIMEVALUE("0:45:0"),A5-A4))

Book13
	A
1
2
3
4	8:00
5	18:00
6	9:15
Sheet1

Cell Formulas
Range	Formula
A6	A6	=IF(OR(A4="",A5=""),"",IF((A5-A4)>5.5/24,(A5-A4)-TIMEVALUE("0:45:0"),A5-A4))

 

[RLPeloquin]

Thanks, working great! I admire you folks so much

 

[etaf]

you are welcome