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

(Iron Bikers) #1

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) #2

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

(Levent KULAÇOĞLU) #3

@Iron_Bikers

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

(Iron Bikers) #4

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) #5

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

(Iron Bikers) #6

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

(Aleksi Alkio) #7

May I ask what was the expression?

(Iron Bikers) #8

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