Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculation not correct
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? |
#2
|
|||
|
|||
Kevin,
Your 15:03 is actually 87:03 (or any multiple of 144 hours higher (which is 6 days), like 231:03): format the cell with the sum for [h]:mm to prevent Excel from hiding the days (multiples of 24 hours) when the sum is more than 24 hours. HTH, Bernie MS Excel MVP "Kevin" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
How can I turn auto correct on or off for one column only? | Excel Worksheet Functions | |||
How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |