Calculate hours worked minus 30 min break if hours worked are greater than 4.5 hours

Please help! I am trying to create a formula that calculates hours worked, but deduct a 30 minute lunchbreak only if the employee worked a total of 4.5 hours or more in that day. See attached spreadsheet

Thank you! the only problem is when I enter time of 10p-12am (hours less than 4.5 hrs in a night shift) it still deducts 30 minutes...

Hello Nikkiw
Why don't you enter the time in the 24 hr format, i.e. 10:00 or 14:15, etc.

I suggest to use a simple subtraction like C5-B5, or if you need the 4.5 hr rule, to

IF(c5-b5>4.5,c5-b5-0.5,c5-b5)

Change the format of the total hours to time format so it looks visually correct. If you want to the total in a calculation, say to determine the pay for the person, you can then you can enter

=(HOUR(D15)+MINUTE(D15)/60)*rate

whatever your rate is

Regards