Click in the cell in the spreadsheet that you would like to insert a time into. Type the following into the cell:TIME ( Type in the hour in 24-hour format in digits, followed by a semicolon.