Return a time given an hour, minute, and second value.
Syntax TimeSerial ( hour, minute, second ) Key hour The hour value (0 - 23). minute The minute value (0 - 59). second The second value (0 - 59).
The hour/minute/seconds may be numeric expressions.
The TimeSerial() function may be used in VBA or in an SQL query.
dtmSaved = TimeSerial (23, 15, 00)
'Returns: 11:15:00 PM
“The hours of folly are measured by the clock, but of wisdom no clock can measure” ~ William Blake
Now - Return the current date and time.
Date - Return the current date.
DoEvents - Delay to allow the operating system to process other events.
TimeValue - Convert a string to a Time.
© Copyright SS64.com 1999-2013
Some rights reserved