Create a function in G8 to calculate the ordinary hours component of the total hours worked on Monday.
Ensure that this function can be copied down into cells G9:G13 to calculate the correct ordinary hours worked on Tuesday right through to Saturday. (Hint: Consider using a nested IF function).
Attached is what I have, but not sure of that is correct...??
This "feels" like homework, just the way you are wording it:
the people here really don't need "Hints.."...if you already know the answer, then PLEASE stop taking up room that people who do need help can use, if not, then why the "Hint"?(Hint: Consider using a nested IF function).
If I need to use an IF, I will, if not, I won't...
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
I do not know the answer this was what I was told. I did it this way, but then was suggested to use a nested IF function... I am still learning this myself, hence the reason I am asking!!
For your question, this is how I would do it ( your way seems to work though, so why fix what is not broken?):
Formula:
Please Login or Register to view this content.
Hope this helps
Last edited by dredwolf; 02-17-2013 at 10:51 PM.
It was suggested I do it this way, as I am not familiar with nested IF functions yet, I thought I would ask here about it. I was not sure what the difference would be. Thank you
In H8 in weekly time sheet, John Bourke and Peter Wills I need a function/formula that will work out how many hours they have worked overtime on Monday, but can be copied and pasted in cells H9:H13.
Attached is said file
Nested ifs can be useful, but like anything they can be over used even when a simpler/better solution is available...i use nested ifs when I cannot come up with something better, but I usually wind up changing them to a lookup type formula, it's usually just more efficient in the end
I believe this is the same project (or homework assignment), but it IS a different question than the other thread.
Well for starters, a little to old for Homework.
As said earlier I am still learning it all myself, so no need to be nasty. I dont think it is associated with a nested IF function, sorry!!
I am unsure of which function will help me with what I am after!!
Well OK,But until I see something says solved on last one, my solution is still the same...the answer to this one lies within the answer to the last one...because it does
As last one is not solved either, which is why I have not changed status on it. The formula you returned for it, kept all days at 8hrs and didnt change so am still unsure about it.
For this one, I do not see how that formula would give me the amount of overtime worked each day. It is a weekly wage sheet, so has to automatically total change when altered.
What is your overtime maximum? If you have a working formula that gives you total hours for the week, you can imbed that formula in this one to give any overtime hours, if any exist.
Assuming overtime is above 40 hours:
=MAX(TotalHoursFormula - 40, 0)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
You never posted that there,
But, it returned what you said you wanted, hours that were less than or equal to 8...if you had made the question about Overtime based on certain days /hours I would have given you those as well, but you have chosen to do it this way...and why monday gets OT is beyond me, but...the formula I gave you gives the reg hours for any day, (ie- hours<=8), so now I need to know ALL the overtime rules...What days get them,What hours, what amounts...your sample DOES NOT show that, so please tell me
Weekly payroll cycle starts monday, standard ordinary working hours are monday to friday 7:30 - 4pm with a 30 minute unpaid lunch break. 8 ordinary hours per day. Sometimes they vary due to meet personal needs. Hours worked in excess of eight ordinary hours are considered overtime. on weekdays the first 2 overtime hours are paid at time and a half and remaining overtime hours are paid at double time rates..Hours worked on a saturday are considered overtime with the first 2 hours worked at time and a half and remaining time at double time rates.What days get them,What hours, what amounts
So..weekdays(mon-fri) 8hrs reg,>8 <10=1.5, >10 =2x
saturdays first2hrs 1.5, 2+ = 2x
and sundays?
Okay...Maybe some other question then
{ I will unsubscribe this thread to make you feel more comfortable }
Yes mon-fri reg hours is 8, then first 2 hours ot is time and a half and anything more is double time. Sat is first 2 hrs is time and a half and 2+ is double time.
See if this will work for you :BSBITU402A - Part B, Task 1_sol2.xlsx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks