Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hey there :) I can assist you with this.
Could you review your formula you posted as an example and ensure the ranges are correct?
Sure so explain further
If I understand your question correctly the formula you have now works except that it wont display a $0 if under 8?
I am working out a base sheet where i cost analyse daily performace and i have set up the page as a time sheet and then have my variables there so that i can calculate the times that they give me just by entering the hrs worked in total.
sooooo if i have a standard day of 8 hrs its multiplyed by standard pay rate
can i send you my xcel sheet?
there were two parts to the question -
Ahh ok, in order to provide you with the best answer I can I will need to see your workbook. You can upload it to www.wikisend.com. After uploading your file copy the File ID or Download link and Paste it here :)
my first formula works out the dble time rate off the hrs because i know that anything over 10 hrs is dble time .... where the problem sits is that anything below 10 should say the value 0
I got ya :). I need your book to work out the details :)
If you can,....
Highlight the cells that need the formula fixed :)
ok sure am just trying to figure out how to upload
Did you follow the link I provided above?
Ahh ok great
yep it didnt work?
Yes sir :) I have it
Ok now walk me through what it should do :)
alright so when you change the hrs to a number greater than 10 it should calculate overtime across the board
i have fixed the zero valu thing for dble time
the problem column is the time and half rate
so between 8 hrs and ten hrs i need it to calculate time and half
Column G "Overtime"?
8 should be 0 and 10 should be 105 but ive go it backwards
yeh so i need a formula that as i put in the total hrs worked for that line it knows to take everything worked above 8 and put it into overtime columns.
sometimes its 1 and sometimes its two and thats where my formula fails
See if this does what you ant :)=IF(AND(E10>7.9,E10<9.9),E10*D2,E10-10)
its also needs to ignore anything above 10 because thats dble time
really hang on
Scrap that...my bad
i put that into cell G12 and changed the relevant things and it doesnt work out
I need an example total to work with :) E10 has 14 in it. What should the overtime be?
overtdime shopuld be 2 hrs and double time is the rest
no worries so it should only recognise the 2 hrs either a 9 = 52.5 or 10 = 105
8 = 0
Sorry for the 20 questions it just helps me understand a little better :)
just fire away
I cant seem to wrap my head around around the formulas you have lol. Here is what I am not grasping....
I apologize but I will have to Opt out as I am out of time. Your new Expert will be here very soon :). They will see what we have discussed and continue from there. Do not rate until you get an answer that works :) Good night. Also...please dont reply back until your new Expert replies to you.