Hourly rates

what I'm trying to do is work out for overtime at work, this is what I got at
the moment,
=SUM(Annual_Lev*7.6*D10*(1+17%)+Days_Worked*7.6*D10+Overtime_worked*1.5*D10)
this works fine for most but we some time work Saturdays which is the first
3 hours @ time and half, then it go's to double time, I know I could not put
it into the nomal over time section, so it had to have it's own sell to work
out.

the cells are set
"D6 days worked", " D7 over time worked", "D8 Overtime Saturday", "D9 Annual
leave", "D10 Hourly rate", I know it has to be a if command but don't know
how to put it.

Saturday overtime can be calculated with

=(Overtime_Saturday*1.5+(MAX(0,Overtime_Saturday-3)*0.5))*Hourly_rate

in the other formula (which I haven't verified, replace Overtime_worked by
(Overtime_Worked-Overtime_Saturday)

BTW, the SUM function is superfluous in your formula.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dreamstar_1961" <Dreamstar1961@discussions.microsoft.com> wrote in message
news:C075A146-E7D6-4E5B-BC7D-59DB1791AC09@microsoft.com...
> what I'm trying to do is work out for overtime at work, this is what I got
at
> the moment,
>
=SUM(Annual_Lev*7.6*D10*(1+17%)+Days_Worked*7.6*D10+Overtime_worked*1.5*D10)
> this works fine for most but we some time work Saturdays which is the
first
> 3 hours @ time and half, then it go's to double time, I know I could not
put
> it into the nomal over time section, so it had to have it's own sell to
work
> out.
>
> the cells are set
> "D6 days worked", " D7 over time worked", "D8 Overtime Saturday", "D9
Annual
> leave", "D10 Hourly rate", I know it has to be a if command but don't know
> how to put it.

It seem to work, thanks for the help Bob, not the why I thought it would be
but then I'm new to using excel, so I have to struggle though as best I can,
I lost the "sum" at the start and see what you mean, as it's not needed, now
need to look to see where else I can lose it from.

"Bob Phillips" wrote:

> Saturday overtime can be calculated with
>
> =(Overtime_Saturday*1.5+(MAX(0,Overtime_Saturday-3)*0.5))*Hourly_rate
>
> in the other formula (which I haven't verified, replace Overtime_worked by
> (Overtime_Worked-Overtime_Saturday)
>
> BTW, the SUM function is superfluous in your formula.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Dreamstar_1961" <Dreamstar1961@discussions.microsoft.com> wrote in message
> news:C075A146-E7D6-4E5B-BC7D-59DB1791AC09@microsoft.com...
> > what I'm trying to do is work out for overtime at work, this is what I got
> at
> > the moment,
> >
> =SUM(Annual_Lev*7.6*D10*(1+17%)+Days_Worked*7.6*D10+Overtime_worked*1.5*D10)
> > this works fine for most but we some time work Saturdays which is the
> first
> > 3 hours @ time and half, then it go's to double time, I know I could not
> put
> > it into the nomal over time section, so it had to have it's own sell to
> work
> > out.
> >
> > the cells are set
> > "D6 days worked", " D7 over time worked", "D8 Overtime Saturday", "D9
> Annual
> > leave", "D10 Hourly rate", I know it has to be a if command but don't know
> > how to put it.
>
>
>

To help you along, SUM does the basic addition math on a range of cells. So
=SUM(A1:A100), or =SUM(A1,A2) is valid. If you are doing the math yourself,
such as A1+A2 this doesn't need SUM. Also, SUM only does addition, it
doesn't multiply or divide, so if your formula has these, it doesn't need to
be included in and SUM function.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dreamstar_1961" <Dreamstar1961@discussions.microsoft.com> wrote in message
news:407FB139-A147-4299-8AA2-10B1FFCEC5CB@microsoft.com...
> It seem to work, thanks for the help Bob, not the why I thought it would
be
> but then I'm new to using excel, so I have to struggle though as best I
can,
> I lost the "sum" at the start and see what you mean, as it's not needed,
now
> need to look to see where else I can lose it from.
>
> "Bob Phillips" wrote:
>
> > Saturday overtime can be calculated with
> >
> > =(Overtime_Saturday*1.5+(MAX(0,Overtime_Saturday-3)*0.5))*Hourly_rate
> >
> > in the other formula (which I haven't verified, replace Overtime_worked
by
> > (Overtime_Worked-Overtime_Saturday)
> >
> > BTW, the SUM function is superfluous in your formula.
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "Dreamstar_1961" <Dreamstar1961@discussions.microsoft.com> wrote in
message
> > news:C075A146-E7D6-4E5B-BC7D-59DB1791AC09@microsoft.com...
> > > what I'm trying to do is work out for overtime at work, this is what I
got
> > at
> > > the moment,
> > >
> >
=SUM(Annual_Lev*7.6*D10*(1+17%)+Days_Worked*7.6*D10+Overtime_worked*1.5*D10)
> > > this works fine for most but we some time work Saturdays which is the
> > first
> > > 3 hours @ time and half, then it go's to double time, I know I could
not
> > put
> > > it into the nomal over time section, so it had to have it's own sell
to
> > work
> > > out.
> > >
> > > the cells are set
> > > "D6 days worked", " D7 over time worked", "D8 Overtime Saturday", "D9
> > Annual
> > > leave", "D10 Hourly rate", I know it has to be a if command but don't
know
> > > how to put it.
> >
> >
> >