How to insert time

1. Select the cell where you wish to display the result.
2. Click the Insert function  icon located at the top toolbar and choose the Additional option,
   
   or right-click within a selected cell and select the Insert Function option from the menu,

   

   or click the  icon located on the Formula tab, or click the icon to the left of the formula bar.
3. Select the Date and time function group from the list.

   

4. Click the TIME function and then click OK.

   

5. In the Function Arguments window, enter the required arguments separating them by commas according to the function syntax:

   TIME(hour, minute, second)

   where

   hour is a number from 0 to 23.

   minute is a number from 0 to 59.

   second is a number from 0 to 59.

   Later on you can edit the arguments using the formula bar.
   
6. Press the Enter button.

The time will be displayed in the selected cell.