Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |