Remember Me?

#1
November 2nd 05, 07:05 AM
 Dreamstar_1961 Posts: n/a
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*D1 0+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.

#2
November 2nd 05, 08:42 AM
 Bob Phillips Posts: n/a
Hourly rates

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" wrote in message
...
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*D1 0+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.

#3
November 2nd 05, 10:46 AM
 Dreamstar_1961 Posts: n/a
Hourly rates

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" wrote in message
...
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*D1 0+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.

#4
November 2nd 05, 11:33 AM
 Bob Phillips Posts: n/a
Hourly rates

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

message
...
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*D1 0+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.

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Excel for payroll Charts and Charting in Excel 0 October 17th 05 05:07 AM Montana Trainer Excel Discussion (Misc queries) 2 September 12th 05 07:48 AM Grace Excel Worksheet Functions 1 June 17th 05 04:15 PM Crys Excel Discussion (Misc queries) 2 May 9th 05 09:21 PM MAM Setting up and Configuration of Excel 2 December 31st 04 05:53 PM

All times are GMT +1. The time now is 09:58 PM.