How To Add Time & Date In Google Sheets
On your computer, open a spreadsheet in Google Sheets.
Highlight the data you want to format.
Click Format. Number.
Click Custom date and time.
Search in the menu text box to select a format. ...
Click Apply.