Elkar, it worked for the overtime but it still total #of in hours in my reg
time. h21 shows my total hours of 67. I need to show 40 in reg time & 27 in
overtime. overtime is in i21. THANK YOU VERY, VERY MUCH. ELKAR I AM NOT SURE
OF WHAT I AM DOING WRONG.

"Elkar" wrote:

Let's say your total hours are in cell A1. Use these formulas:

Regular Hours:
=MIN(A1,40)

Overtime Hours:
=MAX(A1-40,0)

HTH,
Elkar


"Earl A" wrote:

How do i write formul for hours over 40, anything over 40 is Overtime. I
can not find the formul to seperate reg time from overtime. Can some one help
me?