I seem to be having a problem with certain columns in my app not calculating properly (or at all) when previously they did…
=( HOUR([Jin.Clock]-[Hout.Clock]) + MINUTE([Jin.Clock]-[Hout.Clock])/60 + SECOND([Jin.Clock]-[Hout.Clock])/3600 )
Works with the following data:
[Hout.Clock] is 14/08/2018 10:22:17
I get the result: -426177.37
One part of the error, according to the Verify process, is when the MINUTE([Jin.Clock]-[Hout.Clock])/60 part of the calculation divides by 60. There are 31 minutes, which are calculated, which when divided by 60 should show approx 0.5. It shows 0.
So there is some rounding going on in the formula, but not sure what…
Reiterate: This works perfectly well yesterday, but not today…