Excel VBA UDF To Handle Milliseconds

Hi,

I have a DateTime String like - 24-8-2017 15:0:0:48 (Where 48 is milliseconds)

I have written a UDF to convert it to an actual DateTImeFormat. This works just fine. However, I am unable to understand how to get the Milliseconds to be cauculated in the UDF.

Any Help will be appreciated??

Please Login or Register  to view this content.

This may turn out to be a silly question but why are you using Strings and Variants rather than Date/Time variables?

Hi,

Thank you for the response.

That is because the Input is a Text String, not an actual date. And TimeArray is a Variant Array

Thanks for the rep and sharing solution found

Please mark the thread as solved by using thread tool found at top of your initial post.