I am making a timesheet specific to my job and can't figure out how to do the
formulas.


I have my total hours for the week tallied up but I need formulas for the
following categories:

Total Regular Hours (44 or less)
Overtime Hours (44.01 or more)

The formulas I need are...I think:

If the weekly hours is less than 44, the Reg Hrs displays that amount of
hours and the O/T displays 0
If the weekly hours equal to 44 hrs then the Reg Hrs displays 44 and the O/T
Hrs displays 0
If the weekly hours is greater than 44 then the Reg Hrs displays 44 and the
O/T Hrs displays the difference.

I just don't understand how Excell does it.

Any help is greatly appreciated.