In a timesheet if a person works for fewer than five hours there is no
meal break.
Five hours or more the break is 30 minutes.
Six hours or more and the break is 45 minutes.

In this timesheet the times are entered in [h]:mm.

On Sep 7, 6:02*am, Max <d.e.lindst...@gmail.com> wrote:
> In a timesheet if a person works for fewer than five hours there is no
> meal break.
> Five hours or more the break is 30 minutes.
> Six hours or more and the break is 45 minutes.
>
> In this timesheet the times are entered in [h]:mm.


http://www.cpearson.com/excel/overtime.htm

"Max" <(E-Mail Removed)> wrote:
> In a timesheet if a person works for fewer than five
> hours there is no meal break.
> Five hours or more the break is 30 minutes.
> Six hours or more and the break is 45 minutes.
> In this timesheet the times are entered in [h]:mm.

In the cell representing the meal time:

=if(A1<time(5,0,0),0,if(A1<time(6,0,0),time(0,30,0),time(0,45,0)))

where A1 is the time that person works.

On Sep 8, 2:35*am, "joeu2004" <joeu2...@foo.bar> wrote:
> "Max" <d.e.lindst...@gmail.com> wrote:
> > In a timesheet if a person works for fewer than five
> > hours there is no meal break.
> > Five hours or more the break is 30 minutes.
> > Six hours or more and the break is 45 minutes.
> > In this timesheet the times are entered in [h]:mm.
>
> In the cell representing the meal time:
>
> =if(A1<time(5,0,0),0,if(A1<time(6,0,0),time(0,30,0),time(0,45,0)))
>
> where A1 is the time that person works.

That's brilliant! Thank you.