CONCATENATE with 12 hour time

Hi,

I’m using the following expression in a virtual column. The StartTime/EndTIme columns display in 24 hour format. How can I change this to 12 hours?

Thanks

CONCATENATE([Service 1], " ", [StartTime], " “,[EndTime],” ", [First_Last Name])

Try wrapping [StartTime] and [EndTime] in TEXT():

CONCATENATE(
  [Service 1],
  " ", 
  TEXT([StartTime]),
  " “,
  TEXT([EndTime]),
  ” ",
  [First_Last Name]
)
1 Like

Thanks. That was the solution.

1 Like