Try this:
IIf(Right$([time], 1) = ")", Left$([time], Len([time]) - 1), [time])
Assuming that [time] refers to a field in a table or query, or to a text box on a form or report, it's good practice to not re-use system-defined names, which in some contexts may cause confusion - e.g., there is an...