The time is returned in the military and it should be in the 12 am-pm clock.
Cell G 12 9/27/19 (date format)
Cell H 12 5:08 PM (Time format)
Cell I 12 Formula TEXT(G12,"mm/dd/yyyy")&" "&TEXT(H12,"hh:mm")
Cell I 12 Formula Results 09/27/2019 17:08
I would like the results to be displayed in the 12 am-pm clock format 09/27/2019 5:08
This formula works when the time is AM
Thank you for your help.
Cell G 12 9/27/19 (date format)
Cell H 12 5:08 PM (Time format)
Cell I 12 Formula TEXT(G12,"mm/dd/yyyy")&" "&TEXT(H12,"hh:mm")
Cell I 12 Formula Results 09/27/2019 17:08
I would like the results to be displayed in the 12 am-pm clock format 09/27/2019 5:08
This formula works when the time is AM
Thank you for your help.