Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello,

Using answer from @m.a.riosv in this post as a basis -> how to concatenate 12 hr time and the text "AM" or "PM", try:

=A1&" "&TEXT(B1;"HH:MM:SS")

Hello,

Using answer from @m.a.riosv in from this post as a basis -> how to concatenate 12 hr time and the text "AM" or "PM", try:

=A1&" "&TEXT(B1;"HH:MM:SS")