Question

how can you add date and time together in a cell answer in one word​

Answer 1

Explanation:

combine date column and time column into one. You also can use this formula =A2+B2 and then format the result cells as date and time formatting.

Answer 2

Answer:

Insert a static date or time into an Excel cell

On a worksheet, select the cell into which you want to insert the current date or time.

Do one of the following: To insert the date, type the date (like 2/2), and then click Home > Number Format dropdown (in the Number tab) >Short Date or Long Date.