Try:

=MAX(A1-1.66666667,0)

As re-formatted 24 hrs = 1 day
so
40 hrs = 1.6666667 days
--
Gary's Student


"Lee" wrote:

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