Help

Start and end time in the same field?

Topic Labels: Formulas
2555 3
cancel
Showing results for 
Search instead for 
Did you mean: 
KlaDa
5 - Automation Enthusiast
5 - Automation Enthusiast

Dear community 

I’m a nubee here. Trying to schedule a non profit festival.

Is there a formula for getting start and end time into the same column? 

Such as: 

DATETIME_FORMAT({Start Date},'dd. DD. HH:mm'), which is already pretty good.
 
This gives me ie.: Mo. 25. 09:30

I would for the sake of sharing like to include the {End time} ie (11:15) to get this appearance:
Mo. 25. 09:30-11:15
 
Is there a formula to do this?

I tryed DATETIME_FORMAT({Start Date},'dd. DD. HH:mm')DATETIME_FORMAT({End Date},'HH:mm'), but it does not work.
Hoping for an answer.🙏 Uffe from KlaDa
 
3 Replies 3
IbrahimAlfaraj
5 - Automation Enthusiast
5 - Automation Enthusiast

Hey Uffe! Try to use the " & " operator to concatenate the formatted date fields, and add a separator if needed, such as a space or comma. This formula should work:

DATETIME_FORMAT(Date1, 'YYYY-MM-DD HH:mm:ss') & ' | ' & DATETIME_FORMAT(Date2, 'YYYY-MM-DD HH:mm:ss')

 

Try:

DATETIME_FORMAT({Start Date},'dd. DD. HH:mm') & "-" & DATETIME_FORMAT({End Date},'HH:mm')
KlaDa
5 - Automation Enthusiast
5 - Automation Enthusiast

Perfect, thank you so much, both of you!

Hugs