What is the formula for date and time in Excel?
Combine date and time with formula in Excel. There is a very simple formula that can quickly help you combine date column and time column into one. Type this formula =TEXT(A2,"m/dd/yy ")&TEXT(B2,"hh:mm:ss") (A2 indicates the first data in date column, B2 stands the first data in time column, you can change them as you need) into a blank cell,...
DA: 92 PA: 47 MOZ Rank: 53