To replicate the problem, try changing:
WORK values on Mon. 07/09/18, starting with columns F & G in the Calc document below:
Any new values create an incorrect calculation immediately below: in the WEEK 2 TOTAL.
I’ve tried copying & pasting this Table from other working tables, and run into the same issue.
At this point, I’ve tried everything I can think of, including manually re-entering the formulas.
Ackkk - please help,
wildbug123
Please don’t yell (all caps)
Seems to be a field format problem - try [HH]:MM for format code in total.
Probably that, and it tremendously helps to state exactly what fails, e.g. what value entered into which cell leads to an unexpected result in which other cell.
@Ratslinger thanks, I’ll try the new format code. I’ll be back to work on it in an hour or two.
Did it create a solve in the document on your end?
@erAck, the fail is listed in the original post above:
To replicate the problem, try changing: WORK values on Mon. 07/09/18, starting with columns F & G.
Any change in these values creates an incorrect calculation immediately below: in the Week 2 Total.
Did it create a solve in the document on your end?
I try not to answer without testing (have failed at times). The problem exist wherever you calculate your time which is over most of the sheet.
@Ratslinger found the solution:
Seems to be a field format problem - try
[HH]:MM
for format code in total.
as issue is solved pls. check the ‘correct’ sign near the answer and append [solved - format problem] to the title