#### jparks1015

##### New Member

- Joined
- Nov 27, 2017

- Messages
- 10

=(DECEMBER!N8-DECEMBER!M8)-(DECEMBER!$AB$7-DECEMBER!$AA$7)

I then used this formula (below) which corrected the ### error and sums correctly however, it does not subtract the lunch break.

=IF(AND(ISNUMBER(DECEMBER!K6),ISNUMBER(DECEMBER!J6)),DECEMBER!K6-DECEMBER!J6,"")

I need to know how to adapt the new formula to also subtract the lunch break.