MS Access TimeValue() Function

Return a time based on the given string: SELECT TimeValue("17:15:38");

The TimeValue() function returns a time based on a string.

string )

Required. A string that represents a time (from 0:00:00 to 23:59:59)

Return a time based on the given string: SELECT TimeValue("5:15:38 PM");

❮ MS Access Functions