I have a list of start times in A1:A24 and I have an associated list of how long someone can work dependant upon what time they start in B1:B24. The input cells are D6 and E6 (and D10 and E10) and what I would like to achieve is, in cell F6 I would get an "Over" or "Under" based on the calculation and in cell G6 I would see by how much the times entered in D6 and E6 are over or under the allowance in B1:B24. The +1/24 section is because someone who starts work at 12:00 actually starts at 11:00 (I know, I know but that's the way it is). If this is causing an issue I know I could use a hidden helper cell but was trying to keep it as simple as possible. I have "broken" the formula into smaller parts and entered them seperately into other cells and they perform as I expect them to; it's just when I amalgamate them the error appears.
What makes this all the more frustrating is that I have the same data in a copy of Excel 2013 and the formulae work if cell F6 is "Over" but returns FALSE in cell G6 if F6 is "Under".
Thanks for looking