EncodeTime

Returns the fractional portion of a double-precision decimal DateTime value corresponding to the specified time.

The integer portion of the DateTime value indicates the number of days that have elapsed since January 1st, 1900, and the fractional portion of the DateTime value indicates the fraction of the day that has passed since midnight.

Usage

EncodeTime(HH,mm,ss,mmm)

Where: HH - a numerical expression specifying the hours in 24-hour format

mm - a numerical expression specifying the minutes

ss - a numerical expression specifying the seconds

mmm - a numerical expression specifying the milliseconds

Example

EncodeTime(16,29,55,500)  will return a value of 0.6874479167, corresponding to the specified time 
of 16:29:55.500