Hi - I need help on a forumla for calculating hours worked with 1/2 hour lunch/break automatically subtracted. For every 5 hours of work, a 1/2 hour break needs to be subtracted. I'm thinking that would be >=5.5 hours is the key time.
A9 is TIME IN and B9 is TIME OUT.
The formula that I'm using is this: =IF(B9-A9>=0.2291685,B9-A9-0.0208335,B9-A9)*24
This formula works for hours worked up to and including 5 as well as over 5.5, but when an ee works 5.5 hours, it should subtract that 1/2 hour and return 5 hours, but I can't get it to do that. I have tried moving around the conditons with no success.I hope I've been clear. Thanks in advance for any help.
![]()
Bookmarks