View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lee
 
Posts: n/a
Default Problem with formula =MAX(A1-40,0)

I was using the formula =MAX(A1-40,0) to seperate overtime hours from total
hours worked on a time sheet. The cell was formatted "general". Now I need to
format the cells "[h]:mm" but the formula no longer works with that cell
formatting. Is there a fix?
--
Lee Davenport