iWork Numbers 09... How to insert current time... Also.. Shortcut key for insert date

Discussion in 'Mac Apps and Mac App Store' started by philosopherdog, Jan 16, 2009.

  1. philosopherdog macrumors 6502a

    philosopherdog

    Joined:
    Dec 29, 2008
    #1
    Hi,
    in Numbers 09 is there
    1) a shortcut key for inserting the current date?
    2) is there a way to insert the current time? and maybe even do it via a shortcut key?
    Thanx
     
  2. Ninja Dom macrumors 6502

    Ninja Dom

    Joined:
    Feb 12, 2007
    #2
    Just tried it.

    Go to Insert and then Date & Time.

    Pretty simple.
     
  3. jive turkey macrumors 6502

    Joined:
    Mar 15, 2008
    #3
    There is a pretty thorough PDF on the Apple website that has all functions, how to use them, and how to create shortcuts.

    Check here for iWork 09 manuals and stuff.
     
  4. philosopherdog thread starter macrumors 6502a

    philosopherdog

    Joined:
    Dec 29, 2008
    #4
    Yes that is simple, but it's not a shortcut key. :confused:

    Thanx. I'll check it out.
     
  5. Ashka macrumors 6502a

    Ashka

    Joined:
    Aug 9, 2008
    Location:
    New Zealand
    #5
    Make your own shortcut key :)
    System prefs > Keyboard > Keyboard shortcuts.
     
  6. Mal macrumors 603

    Mal

    Joined:
    Jan 6, 2002
    Location:
    Orlando
    #6
    You can create a shortcut for any menu command that doesn't already have one. Open System Preferences and go to Keyboard (Keyboard & Mouse if you're using a Desktop or an earlier version of 10.5 than 10.5.5), then click Keyboard Shortcuts. Click the + button, then type in Date & Time (make sure you get it exactly like the menu command) and then the keyboard shortcut you'd like to use. Now you can go back and use that keyboard command in Numbers. The great thing? You don't even have to close and reopen Numbers for this to work.

    jW
     
  7. philosopherdog thread starter macrumors 6502a

    philosopherdog

    Joined:
    Dec 29, 2008
    #7
    Ok. This is brilliant! I see I can do this for ANY program. What a useful tip.

    I have another, related, problem though. It inserts the date correctly (In date formatted rows), but for rows that I have set for just formatting to the current time, it puts in 12:00 am no matter what time it is. Help!
     
  8. randyjparker macrumors newbie

    Joined:
    Apr 27, 2009
    #8
    http://www.apple.com/iwork/numbers/functions.html

    explains how to insert the current time in a couple of dozen ways, ranging from NOW to just the HOUR or SECOND or a decimal fraction of today ( TIMEVALUE )

    Likewise, dates can inserted in many ways
     
  9. randyjparker macrumors newbie

    Joined:
    Apr 27, 2009
    #9
    HOUR( NOW() ) # returns 11 at 11:00 AM

    MINUTE( NOW() ) # returns 34 at 11:34 AM, not the minutes since midnight

    or

    TIMEVALUE ( NOW() ) # returns 0.5 at Noontime
     
  10. huski macrumors newbie

    huski

    Joined:
    Jun 3, 2008
    Location:
    EU
    #10
    It might be daft question. But I've column of cells formatted to display only time. When I click "Insert Date & Time" I get 12:00 as displayed value instead of actual 12:34. Why is it so?
     
  11. mysterytramp macrumors 65816

    mysterytramp

    Joined:
    Jul 17, 2008
    Location:
    Maryland
    #11
    Bug. You should use the "Provide Numbers Feedback" command under the Numbers menu.

    mt
     

Share This Page