This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

CONCATENATE with 12 hour time

Posted on 11-04-2019 04:00 PM
Michael_Serafin
New Member
Reply posted on --/--/---- --:-- AM

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])

Solved Solved
0 11 1,129
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
Steve
Platinum 4
Platinum 4
Reply posted on --/--/---- --:-- AM

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

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

View solution in original post

Jump to Solution
11 REPLIES 11
Top Labels in this Space