# If formula possible, timesheet over time

1. ## 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.

2. ## Re: If formula possible, timesheet over time

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.

3. ## Re: If formula possible, timesheet over time

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.

4. ## Re: If formula possible, timesheet over time

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.

5. ## Re: If formula possible, timesheet over time

My guess would be
Formula:
`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.

There are currently 1 users browsing this thread. (0 members and 1 guests)