Hello i am trying to create a formula to calculate overtime in excel, the problem i am having is i need to calculate: total time, Regular Time and Overtime, but the overtime is only after 40 Regular time hours have been reached. i have it to where it will calculate overtime but it does it for any hours worked after 8. i just need after 40. i have a copy of the time sheet attached. thank you!!! need this ASAP!!! ALSO i need to keep the formula in total time to calculate from one day into the next, we work 24/7 365 so we can go from one day into the next. i have attached a copy of our time sheet.

Attached Files

Copy of Express Time Sheet new 1.0 Master.xlsx (16.8 KB, 15 views)

OverTime = (TotalTime-MIN(40,TotalTime))

Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

@ tasha

I see your question also posted here and here, if you've posted it elsewhere please add links to those sites too.

If you haven't got a solution yet have a look at the attached.
Columns G and H have been added but can be hidden.

Attached Files

Copy of Express Time Sheet new 1.0 Master_v2.xlsx (17.3 KB, 10 views)

@NoSparks
The basic idea is that the OP should add links himself, not have it done for him.
This helps to see if the OP cares , or does not care, about cross posting etiquette.
If, furthermore, one gives him the answer, what's the point about cross posting rules?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

@ Pecoflyer

It appears we have both changed our view on this.

What a memory !

And you are entirely correct.

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post