Can someone help me format this column so that it displays the time format as HH:mm (1:30 PM)?
I’m using this formula in a virtual column
=CONCATENATE([City_17], ", ", [ETA])
…so that I can have the City and ETA displayed in the same column. But when the time from the ETA shows up, it shows up as hh:mm:ss which is not desired. I have no idea how to achieve this, or
if it’s even possible, so if anyone has any input, it would be greatly appreciated.
Thanks
LinkedIn
Twitter
