If formula possible, timesheet over time
I am having trouble figuring out how to get this timesheet to flow right.
I am looking for a formula for Column G(Regular Hours) & H(OT), the conditions is that after 40 hours it classified as OT, but the variable is that if there is Vacation hours, they are apart of the 40 hours. They are not paid OT on column J or K.
You need to provide a lot more information or change your form.
From your explanation it is impossible to calculate overtime on a daily basis.
You could if you specified that each person works 5 x 8 hour days. But you have not.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
You need to provide a lot more information or change your form.
From your explanation it is impossible to calculate overtime on a daily basis.
You could if you specified that each person works 5 x 8 hour days. But you have not.
Thank You, so I figured it out somewhat, but here is what I'm left with, an If statement within an If state,emt
My logical test is if G19>40,
If its true I want it be F19-(G19-40), however if F19-(G19-40) is a less than 0(or negative), then it needs to read"0"
if false f18.
My guess would beFormula:
Please Login or Register to view this content.
This doesn't quite match up with the file in post #1 as row 19 is Friday and row 20 is Total. If the above formula doesn't do what you want I would suggest uploading another file showing the desired location of the formula and (Manually entered) expected result.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks