I’m working with timestamps, containing milliseconds, like “09:21:50.0558”.

According to this highly upvoted answer, the Excel worksheet function should be able to cope with such an input value but it doesn’t: I get a #Value! error:

What do I need to do in order to get my Excel’s TimeValue() worksheet function work with such timestamps?

I’m working with Excel 365, version 2403.

My Locale is Dutch, Belgium, but when I change this into English, United Kingdom, that does not change anything.

Thanks in advance