Creating a Formula to TextJoin

[Shazir]

Hi, I hope you all are doing well.

I was looking for a formula that will solve the below picture Example.

I want to get the Cells in "Late" Column if C2,D2,E2 have such format "Late - 11:00 AM" then "Late" should be converted with Date as available in C1,D1,E1 and time should be as it is.

and result would be as = 8/1/2020 - 11:00 AM

 

[Shazir]

Exactly you are right.

 

[Shazir]

jasonb75

Sir i need your assistance on this post.

Formula Problem. Google sheets

Hi All, I hope you are doing great. I am using this below formula that which is getting the date and time form the but it is taking the hours ahead as you can see in picture please share the solution. =ARRAYFORMULA(TEXTJOIN("...

www.mrexcel.com