combining them in the same column

marcusben

Hi,

Can we show the date and time by combining them in the same column?

thanks

Andrée Starå

@marcusben

Excellent, and I am too!

Happy to help!

Try something like one of these options.

=JOIN([Starting Date]@row:[Start Time]@row, " - ")

=[Starting Date]@row + " - " + [Start Time]@row

Did that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @marcusben

I hope you're well and safe!

Yes, you could add a so-called helper column and combine them with a formula.

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

marcusben

Hi, @Andrée Starå ,

I'm very well, thank you. I hope you are well, please take care of your health.

Thanks for your answer, but can you give an example of a column and formula as you specified?

thanks,

Andrée Starå

@marcusben

Excellent, and I am too!

Happy to help!

Try something like one of these options.

=JOIN([Starting Date]@row:[Start Time]@row, " - ")

=[Starting Date]@row + " - " + [Start Time]@row

Did that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

marcusben

@Andrée Starå

thanks so much ! its work

Andrée Starå

@marcusben

Excellent!

You're more than welcome!