Formula Problem. Google sheets

[Shazir]

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(", ",TRUE,IFERROR(TEXT($C$1:$AG$1+MID($C8:$AG8,SEARCH(AM$1,$C8:$AG8)+LEN(AM$1)+3,8),"mm/dd/yyyy - (hh:mm AM/PM)"),"")) )

 

[Shazir]

I would like to request that please close the post there was space issue in the sheet. Thanks