Question

The enter data and time in cell , separate the data and time with.......... ​

Answer 1

Answer:

If a cell contains a combined date and time, you can use the INT function to pull the time value into a separate column. Dates are stored as numbers in Excel, with the decimal portion representing the time.

HOPE IT HELPS YOU....

Answer 2

$\huge{\tt{\pink{Answer}}}$

If a cell contains a combined date and time, you can use the INT function to pull the time value into a separate column. Dates are stored as numbers in Excel, with the decimal portion representing the time.