[SOLVED] Automatic timesheets

[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

[Tom Ogilvy]

=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" <gregslaptop@ihug.com.au> wrote in message
news:cuafl7$u20$1@lust.ihug.co.nz...
> 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
>
>

[Greg Brow]

Thanks for the help sorry for the delay in replying

Greg
"Tom Ogilvy" <twogilvy@msn.com> wrote in message
news:eOZIZYeDFHA.4072@TK2MSFTNGP10.phx.gbl...
> =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" <gregslaptop@ihug.com.au> wrote in message
> news:cuafl7$u20$1@lust.ihug.co.nz...
>> 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
>>
>>
>
>