Jul 01 2022 08:19 AM
Hey when I enter a basic formula I keep getting an error code. Same issue as this where it doesn't recognise it. I tried using for example
=mod(row(),)=1
or
=TIME(HOUR(A2), MINUTE(A2), SECOND(A2)) - TIME(HOUR(B2), MINUTE(B2), SECOND(B2))
but none of them worked. What can I do
Jul 01 2022 08:37 AM
SolutionDo you use comma as decimal separator? If so, use semi-colon ; between the arguments of a function
=TIME(HOUR(A2); MINUTE(A2); SECOND(A2)) - TIME(HOUR(B2); MINUTE(B2); SECOND(B2))
The first formula should probably be
=MOD(ROW(), 2)=1
or
=MOD(ROW(); 2)=1
Jul 01 2022 08:56 AM
@Hans Vogelaar Hey thank you so much. That actually solved the issue. I think in the past commas also worked. Haven't thought about trying the semi colon one.
Thanks again
Jul 01 2022 08:37 AM
SolutionDo you use comma as decimal separator? If so, use semi-colon ; between the arguments of a function
=TIME(HOUR(A2); MINUTE(A2); SECOND(A2)) - TIME(HOUR(B2); MINUTE(B2); SECOND(B2))
The first formula should probably be
=MOD(ROW(), 2)=1
or
=MOD(ROW(); 2)=1