You can either use the SCRIPT editor or the SPLIT function to extract the date from one separate cell and the time from another cell. Use the formula =SPLIT(date cell, ""). You can also enter a date stamp with Ctrl+;, a time stamp with Ctrl+ Shift+, or both with Ctrl+ Shift+ Alt+;.