Results 1 to 4 of 4

date time stamp

Threaded View

  1. 02-24-2015, 11:37 AM #1
    Shamz41
    Shamz41 is offline
    Forum Contributor
    Join Date
    09-30-2014
    Location
    Singapore
    MS-Off Ver
    2010
    Posts
    266

    date time stamp

    Hi

    I have this formula.
    =IF(F176<>"",IF(G176="",NOW(),G176),"")

    I need to auto time stamp if the text is "received" and leave it blank if nothing or other texts are typed in the cell F176. Formula will be in G176. Please advise.
    Last edited by Shamz41; 02-24-2015 at 01:17 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need vba code to change date&time stamp as date format dd-mmm-yy in A:A rng
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-03-2014, 06:08 AM
  2. Adding time (more than 24 hours) to date time stamp
    By sidapt in forum Excel General
    Replies: 6
    Last Post: 01-06-2014, 04:08 AM
  3. [SOLVED] Splitting a time stamp into one column for time and another for date
    By Ellsworth Smith in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-19-2013, 02:41 AM
  4. Need to capture date data in a text string containing a date and time stamp
    By Grilleman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-07-2013, 01:14 PM
  5. [SOLVED] Extract a time from a cell with date and time stamp and then perform calculations
    By Marcos Aristotelous in forum Excel General
    Replies: 3
    Last Post: 10-31-2012, 04:36 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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1