Results 1 to 10 of 18

Thread: Inserting time in spreadsheet

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 12-10-2012, 04:33 AM #2
    rollis13
    rollis13 is offline
    Member rollis13's Avatar
    Join Date
    Nov 2012
    Posts
    36
    Rep Power
    0
    Assuming your first Blood Level (242) is in cell B2, in cell C2 (col. Time) copy this formula.

    =IF(ISBLANK(B2),"",IF(C2="",NOW(),C2))

    When you fill in B2 and C2 is empty the time will fill in and will not change unless you empty B2 again.
    Last edited by rollis13; 12-10-2012 at 04:35 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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

Bookmarks

Posting Permissions

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

Forum Rules