Forum Discussion
=--TEXT(D2,"00\:00\:00\.00") Formula
I suspect that the regional settings for the two computers are different.
In particular, for the iPad, the decimal point is a period; but for the laptop, the decimal point is a comma.
Moreover, I suspect that the formula appears to be =--TEXT(D7;"00\:00\:00\.00") on the laptop. Note the semicolon for the parameter (list) separator.
As proof of concept, change the formula to =--TEXT(D7;"00\:00\:00\,00") on the laptop. Note the comma for the decimal separator.
I don't know why the regional settings would be different. So I don't know if the "right" solution is for you to change the regional settings on one device or the other; or for you to change the formula on the laptop as indicated.
Alternatively, perhaps the issue has something to do with the Office 365 settings. I am not familiar with the subscription service.
