Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies. Only from Platform Scholar.
Sub testMilliseconds() Dim dblMillisecond As Double Dim dblResult As Double dblMillisecond = 1.15740740740741E-08 dblResult = dblMillisecond * 1750 Debug.Print Format(dblResult, "DD/MM/YYYY HH:MM:SS.000") With Range("A1") .Value = dblResult .NumberFormat = "DD/MM/YYYY HH:MM:SS.000" End With End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.