View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nevets Nevets is offline
external usenet poster
 
Posts: 10
Default set a minimum value for a cell

I have a sheet with two times, and a formula to figure out how much to
charge, depending on the difference between those two times. I would like to
set a minimum of 4 hours, such that no matter what two times are entered, if
they are less than four hours apart, the result will be 4 hours, but if they
are anything more than 4 hours apart, the result will be the actual
difference.