TimeFormat(time [, mask ])

Returns a custom-formatted time value. If no mask is specified, the TimeFormat function returns time value using the hh:mm tt format.

See also CreateTime, Now, and ParseDateTime.

time

Any date/time value or string convertible to a time value.

mask

A set of masking characters determining the format:

Usage

When passing a date/time value as a string, make sure it is enclosed in quotes. Otherwise, it is interpreted as a number representation of a date/time object, returning undesired results.