Hi everyone! I want to ignore seconds when u...

[Iron_Bikers]

Hi everyone!

I want to ignore seconds when using “CONCATENATE”

I have:

[DESTINATION] > i.e. “WIDE STREET” (type: text) [COLLECTHOUR] > i.e. “18:45” (type: time, ignoring seconds)

and the concatenation column:

[DESTINATION.COLLECT] > “WIDE STREET at 18:45” (type: text)

using appsheet formula as is:

=CONCATENATE([DESTINATION]," at “, TIME([COLLECTHOUR])) or simply =CONCATENATE([DESTINATION],” at ", [COLLECTHOUR])

BUT…

RESULT IS: [DESTINATION.COLLECT] > “WIDE STREET at 18:45:00”

So is there a way to ignore seconds like “IGNORESECONDS([COLLECTHOUR])”?

Thanks in advance!