I have seemingly easy question that I can't seem to figure out. I have a
cell that is a simple sum of a column( it is in time format, i.e. 11:30). I
have another column that i am cuming also with a simple whole number. In
another I am dividing the time reference by the whole number reference. In
one instance it works and the other it is returning a incorrect calculation.
I did a =cell(format,XX) formula to see the difference. All of the cells are
in G9 format so they are the same. This is the correct calculation
=sum(e70/b70) so that translates to =sum(16:28/6) and returns the correct
answer of 2:44. Now the faulty one reads pretty much the same =sum(f70/b70)
which translates to =sum(15:03/6) and this one is returning 14:30. All the
formating is the same as the other and there is no differences of than they
total a different column. I have just typed in the totals and then did these
formulas and it works properly.

I am stumped, can anyone help?