To specify a time (e.g. 11:59:59), the range of numbers for each
TimeSerial parameter should be in the accepted range for the unit. It means 0–23 for hours and 0–59 for minutes and seconds. However, you can also specify relative times for each parameter using any numeric expression that represents some number of hours, minutes or seconds before or after a certain time.
If any parameter exceeds the accepted range for that parameter, then it increments to the next larger unit as appropriate. For example, if you specify
75 minutes, it is evaluated as one hour and
15 minutes. However, if any single parameter is outside the range -32,768 to 32,767, or if the time specified by the three parameters, either directly or by expression, causes the date to fall outside the acceptable range of dates, then an error occurs.
The
Pm.CreateDate method allows to set the value of date and time together including milliseconds.