Forum Discussion
Converting h:mm:ss.000 to decimal seconds
Issue FIXED !!!
Believe it or not, it was closely linked to your earlier comment about what was being used as a "delimiter" !
Although the settings in Excel were correct, and there system settings box was "unchecked" ... I decided to check the System Settings of the Mac Studio device. Reminder that I mentioned it was new.
Well, the Region Settings were set to Switzerland, which is where I am, so I can explain that bit ! :))
Once I switched it to UK, or even USA, the formula works properly, and the trailing decimals, beyond "ss.000" are being displayed properly !!
So thank you for at least directing my mindset in the correct direction.
Much appreciated.
R-
@Hans Vogelaar
BTW ... to answer the earlier question ... on both machines ... under Preferences > Edit ... the "Use System Separators" is UNCHECKED, and the decimal separator is set to "."
(Needless to say, thank you for the follow-ups and trying to assist)
Issue FIXED !!!
Believe it or not, it was closely linked to your earlier comment about what was being used as a "delimiter" !
Although the settings in Excel were correct, and there system settings box was "unchecked" ... I decided to check the System Settings of the Mac Studio device. Reminder that I mentioned it was new.
Well, the Region Settings were set to Switzerland, which is where I am, so I can explain that bit ! :))
Once I switched it to UK, or even USA, the formula works properly, and the trailing decimals, beyond "ss.000" are being displayed properly !!
So thank you for at least directing my mindset in the correct direction.
Much appreciated.
R-