May 22 2021 04:06 PM
May 22 2021 11:53 PM - edited May 22 2021 11:58 PM
Solution
Since basically DATE & TIME are Numeric data therefore need to be insert into cell as single Numeric value.
If you use any of these formulas then it will be TEXT value rather than Numeric.
=TEXT(B1,"mm/dd/yy ")&TEXT(A1,"hh:mm:ss")
Or
=TEXT(B1+A1,"mm/dd/yyyy HH:mm:ss")
If use either
=CONCATENATE(B1,A1)
Or
=B1&A1
then get there Numeric representation like,,
442560.430902777777778 where 442560 is for DATE in cell B1 (03-01-2021) & 430902777777778 for Time in cell A1 (10:20:30).
Therefore I would like to suggest to use simple formula,
=B1+A1
Where B1 has DATE & A1 had TIME.
and the apply Cell Format mm/dd/yyyy hh:mm:ss,, or whichever is suitable to your data, then return value will be remain Numeric.
May 22 2021 11:53 PM - edited May 22 2021 11:58 PM
Solution
Since basically DATE & TIME are Numeric data therefore need to be insert into cell as single Numeric value.
If you use any of these formulas then it will be TEXT value rather than Numeric.
=TEXT(B1,"mm/dd/yy ")&TEXT(A1,"hh:mm:ss")
Or
=TEXT(B1+A1,"mm/dd/yyyy HH:mm:ss")
If use either
=CONCATENATE(B1,A1)
Or
=B1&A1
then get there Numeric representation like,,
442560.430902777777778 where 442560 is for DATE in cell B1 (03-01-2021) & 430902777777778 for Time in cell A1 (10:20:30).
Therefore I would like to suggest to use simple formula,
=B1+A1
Where B1 has DATE & A1 had TIME.
and the apply Cell Format mm/dd/yyyy hh:mm:ss,, or whichever is suitable to your data, then return value will be remain Numeric.