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 recognised date and time format for your region.

Note: If you want to display the date, time or duration in a specific format, you can customise the format for specific cells. For example, you may want to display dates as 2017-06-01 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 shows units of time (month, day and year) 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 centre 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, 31/12 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 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 centre are number keys. A row of buttons at the top shows 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.
സഹായകമായോ?
കാരക്റ്റർ പരിധി: 250
പരമാവധി കാരക്റ്റർ പരിധി 250 ആണ്.
നിങ്ങളുടെ ഫീഡ്ബാക്കിന് നന്ദി.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.