+ Reply to Thread
Results 1 to 3 of 3

Macro to automatically enter time & date

  1. #1
    Registered User
    Join Date
    06-15-2012
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2003
    Posts
    5

    Macro to automatically enter time & date

    hi guys...

    im just new here and i really need your help guys regarding my excel. i am trying to make a tracker of my computer rentals that i can use in my computer shop. i already input some formula and it pretty works. but my problem is that, every time i add an addition rental on the succeeding rows, the time and date of the previous time is always changing in current time. attached here is the example of my spreadsheet.. sorry for the apperance because im just novice in creating this kind of tracker. hopefully you can help me guys.. i owe this one...thanks again..

    Untitled.jpg

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Macro to automatically enter time & date

    Hi abbiekoh,

    Not sure what formula you have in the cell...
    Suggest you to upload a sample workbook. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com

  3. #3
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    883

    Re: Macro to automatically enter time & date

    Code goes in a worksheet module(right click the sheet tab and select view code). Change the range if necessary as you have your columns set up as numbers and I have never set up my computer that way.

    Please Login or Register  to view this content.
    If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved

    Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1