Results 1 to 12 of 12

date and time needs to be auto populate when i insert data in another column.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-12-2013
    Location
    india
    MS-Off Ver
    Office 365
    Posts
    218

    date and time needs to be auto populate when i insert data in another column.

    Hi Team,

    I have the function below in A1 column, below function I was tried to use because when I enter data in B column i need the data entered date and time in B column, however I have entered data in B1 and B2 column around 10 am and I got the exact date/time populated in A1 & A2 column, I am happy with that but after 2 hours I entered data in B3 and B4 column but the issue is data & time has been changed to current date from A1 to A4 column. Please advise and assist us on getting new function to auto populate the data and time in A column. No need macrosssssssssssss.

    =if(COUNTA(b1)>0,Now(),"")


    Regards
    Girish
    Last edited by Giri.hb; 06-29-2014 at 01:14 AM. Reason: changed the title

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Payroll time sheet calculation where time exceeds 24 hours
    By Rolo1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-23-2014, 08:57 AM
  2. [SOLVED]Time/Date calculation to check response time
    By tailz in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-01-2013, 10:20 AM
  3. [SOLVED] Calculation of seconds from Start time and End time
    By uday1969 in forum Excel General
    Replies: 12
    Last Post: 06-13-2012, 03:21 PM
  4. Replies: 11
    Last Post: 05-20-2011, 02:09 PM
  5. Specific time period calculation from a time range
    By Khaldon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2011, 06:44 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1