I seem to be having a problem with certain co...

[Green_Gorilla]

I seem to be having a problem with certain columns in my app not calculating properly (or at all) when previously they did…

The formula:

=( 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

and

[Jin.Clock] is

14/08/2018 10:54:00

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…

Any ideas?

Reiterate: This works perfectly well yesterday, but not today…