View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
smoss smoss is offline
external usenet poster
 
Posts: 4
Default @Need help with a formula

Sorry if in the wrong category...........

My Formula in D6
=IF(AND(ISNUMBER(C6),ISNUMBER(C5)),IF(IF(C6-C5$N$3,C6-C5-$H$3,IF(C6-C50,C6-C5,0))=0,"",IF(C6-C5$N$3,C6-C5-$H$3,IF(C6-C50,C6-C5,0))),"")

C5 = Employee start time
C6 = Employee stop time
D5 = 1 or .5 for lunch
I would like the number that I enter into D5 (either 1 or .5) to be
subtracted from D6

Thanks In Advance

--
smoss