Automatic timesheets

  • Thread starter Thread starter Greg Brow
  • Start date Start date
G

Greg Brow

What I am looking to do is,

I have a roster where I have automatically works the hours out but the
problem I have is if the person works more than 5 hours they take a half an
hour break and if they work more than 8 hours they are entitled to a 1 hour
break.

How can I get this to happen automatically

Thanks in advance

Greg
 
=if(hours < 5,0,if(hours<8,.5,1))

hours is a cell that holds hours worked as decimal numbers (rather than
excel time values)

would be a generalized approach.
 
Back
Top