TRYING TO SUM D4:N4 BUT SOMETIMES I HAVE CODED THE CELL TO SHOW NOT ONLY NUMBERS BUT ALSO OVERTIME NUMBERS ("8/1"). CURRENTLY, AM USING THIS FORMULA:
=SUM(IF(MID(D4,2,1)="/",LEFT(D4,1),D4),SUM(IF(MID(E4,2,1)="/",LEFT(E4,1),E4),SUM(IF(MID(F4,2,1)="/",LEFT(F4,1),F4),SUM(IF(MID(G4,2,1)="/",LEFT(G4,1),G4),SUM(IF(MID(H4,2,1)="/",LEFT(H4,1),H4),SUM(IF(MID(I4,2,1)="/",LEFT(I4,1),I4),SUM(IF(MID(J4,2,1)="/",LEFT(J4,1),J4),SUM(IF(MID(K4,2,1)="/",LEFT(K4,1),K4),SUM(IF(MID(L4,2,1)="/",LEFT(L4,1),L4),SUM(IF(MID(M4,2,1)="/",LEFT(M4,1),M4),SUM(IF(MID(N4,2,1)="/",LEFT(N4,1),N4))))))))))))
MY PROBLEM IS THAT IT ONLY WORKS WITH WHOLE NUMBERS. IF I HAVE (7.5/1.5) IT DOES NOT READ THAT AS SUCH. I AM SUMMING THIS RANGE TO TWO DIFFERENT FIELDS: REG (FOR REGULAR TIME) AND OT (FOR OVERTIME).
THE REASON AM SPANNING THIS RANGE IS WE ARE TRYING TO SHOW WHICH JOBS RECEIVED HOW MANY HOURS OF WORK.