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.

--
Regards,
Tom Ogilvy

"Greg Brow" wrote in message
...
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

Thanks for the help sorry for the delay in replying

Greg
"Tom Ogilvy" wrote in message
...
=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.

--
Regards,
Tom Ogilvy

"Greg Brow" wrote in message
...
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