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!

[Iron_Bikers]

Tried using MINUTE() and HOUR() but that only works with duration type

[Levent_KULACOGL]

@Iron_Bikers

=CONCATENATE([DESTINATION]," at “,HOUR([COLLECTHOUR] - “00:00:00”),”:",MINUTE([COLLECTHOUR] - “00:00:00”))

[Iron_Bikers]

OH YES! Awesome!. I didnt tried adding a math operation cuz I tought the system will interpretate as time, so give a mismach error.

Thank you very

much!

[Aleksi_Alkio]

Or maybe just LEFT(CONCATENATE([COLLECTHOUR]),5)

[Iron_Bikers]

LEFT seems not works. Is there a way to add zero, and see “12:05” instead “12:5”?

[Aleksi_Alkio]

May I ask what was the expression?

[Iron_Bikers]

@Aleksi_Alkio Solved, LEFT() is working (sure typed wrong sentence) so there isnt problem with left zero. Thanks for all!