+ Reply to Thread
Results 1 to 1 of 1

Google Spreadsheet having problem in Time Stamp Formula

  1. #1
    Registered User
    Join Date
    03-23-2020
    Location
    Pakistan
    MS-Off Ver
    Office365
    Posts
    1

    Google Spreadsheet having problem in Time Stamp Formula

    Hello Every one,

    I need help, actually i put the time stamp formula (=IF(I11="Activity Finish",IF(J11="",NOW(),J11),"")) but it some times doesnt show correct date.
    For example : i have posted activity finish on 20 march but time stamp showing 23 march .
    Some Cells are working properly but some time it jumps to 2 days ahead in time stamp colum .. it must be some malfunction in formula.
    Can any help me to reslove this probelm or give me another formula to add time stamp without using of script in google sheets.

    Thanks
    Last edited by Pepe Le Mokko; 03-23-2020 at 06:55 AM. Reason: Moved to correct subforum

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Migrate VBA that sets time stamp to Google Sheets
    By marko737 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 8
    Last Post: 12-15-2019, 03:03 PM
  2. Migrate VBA that sets time stamp to Google Sheets
    By marko737 in forum Excel General
    Replies: 6
    Last Post: 12-15-2019, 02:32 AM
  3. Google spreadsheet formula projection
    By Perlapimpim in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-23-2019, 04:17 AM
  4. Static date and time stamp excel VBA Problem
    By shaykstrade in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2017, 12:50 PM
  5. Problem with converting JSON into Google Spreadsheet
    By HannibalLec in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 05-06-2015, 07:54 AM
  6. Problem with converting JSON into Google Spreadsheet
    By HannibalLec in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-06-2015, 07:54 AM
  7. Problem with Time Stamp in comments...
    By corty_d in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-10-2008, 05:04 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