- Home
- Docs
- User guides
- Spreadsheet Editor
- Inserting time
Inserting time
- Select the cell where you wish to display the result.
- 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 theicon located on the Formula tab, or click the
icon to the left of the formula bar.
- Select the Date and time function group from the list.
- Click the TIME function and then click OK.
- 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. - Press the Enter button.
The time will be displayed in the selected cell.
Host ONLYOFFICE Docs on your own server or use it in the cloud
Article with the tag:
Browse all tags