+ Reply to Thread
Results 1 to 2 of 2

Help with repeating Time Stamps

  1. #1
    Registered User
    Join Date
    08-30-2013
    Location
    Northern VA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Help with repeating Time Stamps

    I'm having trouble coming up with a function which will repeat a given string when a true/false condition is met. I've attached an example:

    In column A you'll see matching row numbers with differing data in column B. I'm cleaning that data in columns C:F, pulling only the strings I need. What I want to do is repeat those cleansed strings in column G where the Ticket IDs match.

    Any help you can offer would be greatly appreciated!

    Thanks

    Time_Stamp Problem.xlsx

  2. #2
    Registered User
    Join Date
    08-05-2013
    Location
    USA
    MS-Off Ver
    2010
    Posts
    76

    Re: Help with repeating Time Stamps

    See the attached. I added two columns to assist with calculations. The one caveat of the formula is that it is dependent on only one user per record (ie - in columns C-F, only one entry total for that row is possible).

    Hope this helps.
    Attached Files Attached Files

+ 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. Excel 2007 : Difference between two time stamps
    By rwinsett in forum Excel General
    Replies: 3
    Last Post: 02-21-2012, 06:09 PM
  2. Converting time stamps to time intervals
    By enhydra in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2011, 04:51 PM
  3. Time Difference in hours between two date time stamps
    By Cipher in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-17-2010, 10:24 AM
  4. [SOLVED] I need to find the yy/mm/dd AND hh:mm:ss between 2 time stamps
    By Pontoon in forum Excel General
    Replies: 5
    Last Post: 06-22-2006, 08:25 AM
  5. time stamps detailing last save time
    By sam1 in forum Excel General
    Replies: 4
    Last Post: 01-12-2005, 03:21 PM

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