Explanation of miliseconds conversion

[Llupo01]

Hello, I have quick question please.

in function below, if I use 2000 for miliseconds byval, what exactly does the calculation / 24 / 60 / 60 / 1000? What 2000 means in this moment for vba? Is it number of days, hours?

Function waitTime(ByVal milliSeconds As Double)
    Application.Wait (Now() + milliSeconds / 24 / 60 / 60 / 1000)
End Function

Thank you,

brgds,
Tomas

 

[AlanY]

excel store 1 day as 1, ie x24 hrs x 60 min x 60 seconds x 1000 to get the milliseconds

the function just reverse the process from milliseconds back to day

 

[Llupo01]

Got it, thank you very much