Articles with the tag:
Try in the cloud
Try in the cloud

How to insert time


If you need to insert the current time in a cell, e.g. to show the moment of issuing an invoice or purchasing an item, the ONLYOFFICE Spreadsheet Editor has a specific function designed to do exactly that.

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

    insert function cell menu

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

    date and time function group

  4. Click the TIME function and then click OK.

    time function

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

    TIME(hour, minute, second)


    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.
    date and time arguments window date and time arguments window
  6. Press the Enter button.

The time will be displayed in the selected cell.

time result

How to create a new document?
Try now for free Try and make your decision No need to install anything
to see all the features in action
You Might Also Like This: