Conversations involving multiple participants, allowing collaboration and information sharing in Teams
to make your formula work for AM/PM had to change your "3" to a "6" to account for the extra characters
=IF(LEFT(RIGHT([@Input],6),1)=":",
"["&[@Input]&"]",
".")
and for whatever reason my teams post the time below regardless of who Person 1/2 is i had to change P52
=IF([@IsDateFormat]<>".",
IF(A8=$A$2,
[@IsDateFormat] & " " &A8,
IF(A10="Edited",
[@IsDateFormat] & " " &A11,
IF(A8=$A$4,
[@IsDateFormat] & " " &A8,
"."))),
".")
I think some of your formulas and fields are redundant but assuming you kinda just slapped this together to get your desired result. i appreciate the start and ill retool to my needs when something else about teams copy pasting pisses me off