#1   Report Post  
Old November 2nd 05, 07:05 AM
Dreamstar_1961
 
Posts: n/a
Default 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   Report Post  
Old November 2nd 05, 08:42 AM
Bob Phillips
 
Posts: n/a
Default 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   Report Post  
Old November 2nd 05, 10:46 AM
Dreamstar_1961
 
Posts: n/a
Default 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   Report Post  
Old November 2nd 05, 11:33 AM
Bob Phillips
 
Posts: n/a
Default 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.








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
salary, hourly wage plus commision Excel for payroll Charts and Charting in Excel 0 October 17th 05 05:07 AM
CD Interest Rates and Lengths Comparisons Montana Trainer Excel Discussion (Misc queries) 2 September 12th 05 07:48 AM
Calculating non-financial rates Grace Excel Worksheet Functions 1 June 17th 05 04:15 PM
Trying to develop a shipping calculator to compare courier rates Crys Excel Discussion (Misc queries) 2 May 9th 05 09:21 PM
How do I set up a spread sheet to calculate pay rates for teacher. MAM Setting up and Configuration of Excel 2 December 31st 04 05:53 PM


All times are GMT +1. The time now is 07:31 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017