@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
|