Add a date, time, or duration in Numbers on iPhone

Numbers has special keyboards to simplify adding and editing date and time information and units of time (durations) in tables. You can also use the standard keyboard to type any recognized date and time format for your region.

Note: If you want to display the date, time, or duration in a specific format, you can customize the format for specific cells. For example, you may want to display dates as 2017-01-06 instead of 01/06/2017.

Enter any date or time in a cell

The date and time keyboard has shortcut buttons that let you quickly edit dates and times in cells.

The date and time keyboard. A row of buttons near the top show units of time (month, day, and year) that you can increment to change the value shown in the cell. There are keys on the left for today, now, and AM/PM, and number keys in the center of the keyboard.
  1. Go to the Numbers app on your iPhone.

  2. Open a spreadsheet, tap a cell, then if the keyboard isn’t open, tap the Show Keyboard button at the bottom of the screen.

  3. Tap the Date and Time Keyboard button at the top of the keyboard.

  4. To enter values, do one of the following:

    • Add the current date and time: Tap “now.”

    • Add today’s date: Tap “today.”

    • Type a date or time: Tap the keyboard keys to manually enter dates and times—for example, 12/31 or 2:15 PM.

  5. To edit values, do any of the following:

    • Increment the value: Tap - or + on the button at the top of the keyboard for the unit (month, day, hour, and so on) you want to change. Each tap decreases or increases the unit by 1.

    • Manually enter a change: Select the value you want to change, then type the new value.

Tip: You can select a blank cell then tap a button to enter a date or time relative to the current date or time. For example, if you want to enter today’s date but one year from now, tap + on the year button.

Quickly add the current date or time to a cell

Use the cell action menu to quickly add the current date or time to a cell.

  1. Go to the Numbers app on your iPhone.

  2. Open a spreadsheet, tap a cell, then tap the Cell Action menu button at the bottom of the screen (or tap the Action menu button in the top-right corner of the keyboard).

  3. Tap Current Date or tap Current Time.

Enter and edit durations (units of time)

You can use the duration keyboard to enter and quickly edit units of time in cells. For example, 3h 40m 15s (or 3 hours 40 minutes 15 seconds).

The duration keyboard with keys on the left for weeks, days, hours, minutes, seconds, and milliseconds. In the center are number keys. A row of buttons at the top show units of time (weeks, days, and hours), which you can increment to change the value in the cell.
  1. Go to the Numbers app on your iPhone.

  2. Open a spreadsheet, tap a cell, then if the keyboard isn’t open, tap the Show Keyboard button at the bottom of the screen.

  3. Tap the Duration Keyboard button at the top of the keyboard.

  4. Tap a number key for the first value you want to enter, then tap its corresponding unit key on the left side of the keyboard

    For example, to enter 2 weeks, tap 2, then tap “w.”

  5. To edit values, tap - or + on the button at the top of the keyboard for the unit (week, day, hour, and so on) you want to change.

    Each tap decreases or increases the unit by 1.

  6. Repeat these steps for each value you want to enter.

  7. To move to a different cell, tap the Next Row key or the Next Column key.

By default, cells containing duration data are automatically formatted to display all the time units you enter. You can change this setting so duration cells display only certain units of time (for example, only hours, not minutes), even if more precise duration values have been entered in the cell.

Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.