Keyboards for entering time-related data

There are two kinds of time-related data you can specify in a cell or formula argument:

Time data can be sorted and used in formulas.

Use the date and time keyboard to specify when an event occurred.

Date and Time keyboard

Use the duration keyboard to specify how long an event lasted.

Duration keyboard

You can change the format for how dates, times, or durations are displayed, and you can preformat groups of cells to accept date and time or duration data. To learn how, see Format cells to display different types of data.

Enter a date and time or duration in a cell

  1. Double-tap a cell, then tap Date and duration keyboard button to the left of the input bar (above the keyboard).

  2. Tap Date & Time or Duration to select the keyboard you want; the key is blue when its keyboard is selected.

  3. Tap the tokens in the input bar, then enter a corresponding value for each unit.

    You can ignore any units you don’t want to specify.

    If you’re entering a date and time, the keys in the keyboard change to match the kind of data required by the token you selected.

  4. Tap Done.

Enter a date and time or duration as part of a formula or function

  1. Double-tap a cell, then tap Function keyboard button to the left of the input bar (above the keyboard) to select the keyboard for formulas and functions.

    You can create your own formula that includes date and time or durations.

    You can also insert a function, then specify time data as values for variables in that function. To add a function, tap functions, then tap to choose a function. Tap the function token that you want to enter a time value for, such as “start-date.”

  2. Tap Date and time keyboard button in the keyboard.

  3. Tap Date & Time or Duration to select the keyboard you want; the key is blue when its keyboard is selected.

  4. Tap the tokens in the input bar, then enter a corresponding value for each unit.

    You can ignore any units you don’t want to specify.

    If you’re entering a date and time, the keys in the keyboard change to match the kind of data required by the token you selected.

  5. Tap Done.