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!
Tried using MINUTE() and HOUR() but that only works with duration type
=CONCATENATE([DESTINATION]," at “,HOUR([COLLECTHOUR] - “00:00:00”),”:",MINUTE([COLLECTHOUR] - “00:00:00”))
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!
Or maybe just LEFT(CONCATENATE([COLLECTHOUR]),5)
LEFT seems not works. Is there a way to add zero, and see “12:05” instead “12:5”?
May I ask what was the expression?
@Aleksi_Alkio Solved, LEFT() is working (sure typed wrong sentence) so there isnt problem with left zero. Thanks for all!
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |