2021.05.06 - Csütörtök UP 7:00 - smink

2021.05.06 - Csütörtök UP 8:30 - smink

2021.05.06 - Csütörtök UP 13:00 - tetoválás

2021.05.06 - Csütörtök UP 14:30 - GO HOME DRINK BEER

2021.05.06 - Csütörtök UP 18:30 - tetoválás

can I continue to use column B somehow?

in the original spreadsheet doing this

Problem Fixed. It was the open ended ranges

you are welcome

with text function missing 7:00

can the zeros be inserted somehow?

is that it - the 08:00? - change from h:mm to hh:mm

={filter(A1&" "&B2&" "&text(A3:A27;"hh:mm")&" - "&B3:B27;B3:B27<>"");filter(A1&" "&D2&" "&text(A3:A27;"hh:mm")&" - "&D3:D27;D3:D27<>"")}

I have to leave soon - any other questions before I go?

how does that look now?

you are the best !

perfect thank you very much !

and can I continue to write UP afterwards?

you are very welcome

Please feel free to post more questions

Also, please respond with Solution Verified on reddit

good luck - and post more questions any time