What formula would I use to calculate breaks automaticaly, for example on an
eight hour shift a one hour break should be deducted, in a six to eight hour
shift half an hour should be deducted. Anything less than six hours and no
break is deducted. I have set up a spread sheet to work out the hours worked
but I need to take break off this, I would rather the spreadsheet calculate
this for me, than me have to input the breaks manually.
Bookmarks