Forum Discussion
Solved
Issue with entering formula
Hey when I enter a basic formula I keep getting an error code. Same issue as https://support.microsoft.com/en-us/office/how-to-avoid-broken-formulas-8309381d-33e8-42f6-b889-84ef6df1d586 where it does...
Do 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
Do 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
HansVogelaar 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
