Automatic Date and Time Input

Would like to have computer’s current date and time automatically appear in a spreadsheet, in column A and on the next row, at each instance that a certain spreadsheet is (re)opened, and in the following format:

1902191315

which will be understood by me as 2019 Feb 19th 1:15 PM.  I will then manually input, into that dated row, my desired data in the cells of columns B, C, D and so on, then save the document and close Excel.  When I next (re)open the spreadsheet (hours or days later), the then current date and time will automatically appear in column A on the next row.  I will eventually graph my data (y axis) against the date/time (x axis), where the data points will be spaced irregularly in the x axis direction according to the date/time when the data was input into the speardsheet.  Using Excel 2013 in Windows 10 Pro.

Though computer and Windows literate, I’m not even an Excel newbie (!), so your response should be step by step and in layman’s terms.  As a retired academic physician who always freely answers friends’ and neighbors’ medical questions in detail, I very much appreciate your time and consideration in responding to me.  Thank you.

By: Dan

11 thoughts on “Automatic Date and Time Input

  1. adidas nmd r1

    Youre so cool! I dont suppose Ive learn anything like this before. So nice to search out any individual with some authentic thoughts on this subject. realy thanks for beginning this up. this website is something that is needed on the web, somebody with somewhat originality. useful job for bringing something new to the internet!

  2. kd shoes

    This is the correct blog for anybody who needs to search out out about this topic. You notice a lot its virtually onerous to argue with you (not that I truly would want匟aHa). You undoubtedly put a new spin on a subject thats been written about for years. Great stuff, simply great!

  3. ultra boost 3.0

    I抎 need to check with you here. Which is not one thing I normally do! I take pleasure in studying a submit that may make people think. Additionally, thanks for allowing me to remark!

  4. quest bars cheap coupon twitter

    You’re so cool! I don’t believe I’ve truly read something like that before.
    So good to find somebody with genuine thoughts on this issue.
    Seriously.. thanks for starting this up. This site is one thing that is required on the
    web, someone with some originality!

Leave a Reply

Your email address will not be published. Required fields are marked *