Results 1 to 10 of 18

Thread: Inserting time in spreadsheet

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Member
    Join Date
    Nov 2012
    Posts
    33
    Rep Power
    0

    Inserting time in spreadsheet

    I have a spreadsheet that I keep track of my blood sugar levels (I'm a diabetic), and it's set up like this:

    Code:
    Date                   Blood Level    Time              Blood Level    Time                          Blood Level    Time                          
    Sun-Dec-09		242	      7:30 AM		206	       1:21 PM
    Each time I take my blood sugar level, I must record the level and the time. The level fluctuates, but the time has to be entered manually. I have tried =now() as the time, but every time I open the spreadsheet, anything in the =now() changes to the current time. 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
    Last edited by papabill; 12-09-2012 at 11:39 PM.

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
  •