Last updated: August 26, 2026.
The TimeValue function converts a recognizable time expression to a Date value containing only the time portion.
Syntax
TimeValue(time)| Argument | Description |
|---|---|
time | Date or text expression containing a valid time |
Examples
TimeValue("2:30 PM")
StartTime: TimeValue([StartedAt])
CurrentTime: TimeValue(Now())Text parsing follows regional settings. TimeValue raises an error when the expression contains invalid date information.
See Microsoft’s Access function reference for related expression functions.
