| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Timesheet maximum hours problem
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| comparing a value in a cell to see if it is higher than a number | Excel Worksheet Functions | |||
| add hours (calculated by functions) on a timesheet | Excel Worksheet Functions | |||
| How can I make a timesheet to figure my hours and payrate? | Excel Worksheet Functions | |||
| Timesheet Problem | Excel Discussion (Misc queries) | |||
| Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions | |||
Threaded Mode
