Timesheet maximum hours problem
Hi!
Try this:
=MIN(D24,44/24)
Format the cell as [h]:mm.
Biff
"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
|