A2=2004-09-01 (formatted as date)
B2=00:08:25 (formatted as time)
I want C2 to look like '2004-09-01, 00:08:25'. It's formatted like
'YYYY-MM-DD, tt:mm:ss'
To get the info I use '=EXTEXT(A2;1;10)&", "&EXTEXT(B2;1;8)' but I get
'38231, 00:08:18'
How do I get it to work?
Bookmarks