View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Using an IF statement on time based data

DonB-
Now that I think on it a little longer, your original formula appears
to have a logic flaw in it. Your formula says
=if(((d12-c12)+(f12-e12)+(h12-g12))=8,8
.... which would award someone with 8 hours' work if they worked
anything less than 8.