Thread: Don't want 0.00
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David David is offline
external usenet poster
 
Posts: 31
Default Don't want 0.00

David wrote

=MAX(0,80-(SUM(N8:N12,N15:N19))-SUM(S8:V12,S15:V19))


Actually, I had to change the formula to:
=MAX(0,40-(SUM(N7:N13))-SUM(S7:V13))+MAX(0,40-(SUM(N14:N20))-SUM(S14:V20))
because used Annual Time is calculated in seperate weeks

--
David