View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karl Davidson Karl Davidson is offline
external usenet poster
 
Posts: 1
Default 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?