| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Make a cell not equal less than a certain number
I am making a time sheet that has the punch in and out times. An employees
work day is a minimum of 5 hours or greater. For an example: an employee works 3 hours, they received 5 hours credit. I have a cell that has the total hours work and another cell with their hourly pay. What is the formula to make the total days hour cell not less than 5 hours? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I make cell "yes" equal 1, "no" equal 0 | Excel Discussion (Misc queries) | |||
| How to make text in a cell equal a number | Excel Discussion (Misc queries) | |||
| make a single cell always equal zero | Excel Worksheet Functions | |||
| make cell length always equal 10 | Excel Discussion (Misc queries) | |||
| How do I make one cell equal to another | Excel Worksheet Functions | |||
Threaded Mode
