Start and end time in the same field?

[KlaDa]

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

[IbrahimAlfaraj]

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')

[TheTimeSavingCo]

Try:

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

[KlaDa]

Perfect, thank you so much, both of you!

Hugs