I concur with Whizbang, also using TEXT function is almost always a bad idea. As the name implies it returns text formatted results which can't be easily used for calculations. In N6 use just
=I6-H6+(L6-K6)
and format the cell as h:mm
Then you can just use a SUM formula in N11
Bookmarks