Results 1 to 10 of 18

Thread: Inserting time in spreadsheet

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Dec 2012
    Posts
    1
    Rep Power
    0
    Quote Originally Posted by papabill View Post
    I need some way to automatically enter the ACTUAL time and keep it from changing.

    Does this make sense? And, can anyone help me?

    Thanks
    Excel has some keyboard shortcuts to do this:
    Insert Date: Ctrl + ;
    Insert Time: Ctrl + Shift + ;

    Alternatively, here are two other slightly more tedious, (but more flexible) ways to turn dynamic equations into fixed values:
    1) After you've imputed your equations into want "Copy" then "Paste as Values" over the same cell(s). Can be for a single cell or a range of cells.
    2) While imputing an equation highlight the part you no longer want to be volatile and press "F9" (e.g. highlight the "=NOW()" in your formula bar and press "F9", then "Enter" to keep the changes.)

  2. #2
    Member
    Join Date
    Nov 2012
    Posts
    33
    Rep Power
    0
    Thanks, but the solution that rollis13 gave me works beautifully. But I do appreciate the extra info. Who knows, I might be able to use it somewhere else.

Similar Threads

  1. Calculate Time Difference Between Time In HH:MM
    By Stalker in forum Excel Help
    Replies: 8
    Last Post: 03-28-2013, 03:27 PM
  2. Budget Spreadsheet Template
    By rich_cirillo in forum Excel Help
    Replies: 1
    Last Post: 02-12-2013, 10:32 PM
  3. Displayin Date/Time in "original" time zone
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 04-21-2012, 02:02 AM
  4. Spreading a time range (shift time, etc) in columns.
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 1
    Last Post: 08-23-2011, 11:45 AM
  5. FreezePane In A Userform SpreadSheet Control 11.0
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 05-15-2011, 05:49 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •