=CONCATENATE date and time

LO Version: 7.5.0.3 (X86_64) / LibreOffice Community
Build ID: c21113d003cd3efa8c53188764377a8272d9d6de
CPU threads: 4; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: en-CA (en_CA); UI: en-US
Calc: CL threaded

If column A is formatted as Date YYYY-MM-DD and column B is formatted as Time HH:MM:SS is it possible to =CONCATENATE columns A and B to column C formatted as Date YYYY-MM-DD HH:MM:SS

I should have done a little more digging before firing off the question. This works:

=CONCAT(TEXT(A2,“YYYY-MM-DD”)," ",TEXT(B2,“HH:MM”))

1 Like

Why not enter in C2 the formula =A2+B2 and format it as desired? YYYY-MM-DD HH:MM

Times are just fractions of a day

2 Likes

Thank you Mr. Occam!