=Min(D24,time(44,0,0))

and format as time

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Good Time" wrote in message
...
I have created a time sheet for biweekly payroll, but I have one
problem.

Cell: I12 is the total for one week

Cell: D24 is the above total copied

Cell:D26 is regular hours worked - and this is where I have the
problem.

I want this cell to copy the value from D24 or input 44:00 hours,
which ever is less, in time format.

Can you help

Thank you