The mod 12 is faster: ``` trim(substr(EventTime, 1, 2), ':') % 12 + iif(instr(EventTime, 'PM') > 1, 12, 0) ```