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 |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |