Let's say your Total Hours are in Cell A1.

For your "Regular Hours" use this formula:

=MIN(A1,40)

For you "Overtime Hours" use this formula:

=MAX(A1-40,0)

HTH,
Elkar


" wrote:

Anyone out there can help me with a worksheet project? I am trying to
set up a timesheet formula where I can input the total number of hours
worked in the wek and then have it calculate into two seperate cells,
regular hours (hours under 41) and overtime (hours over 40). I know
this seems simple,but how do I do it if the hours are less than 40?
Does this make sense? This is stumping me right now.