Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: shifting data down a row?==SOLVED thanks TsTom

  1. #11
    New Member
    Join Date
    May 2002
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you so much for all your help. This board is filled With extreme intelligence. A very good resource!

    I have reviewed my problem and have one more question.

    If cell A1 has a Dynamic Data Exchange entry of either 1 or 0. Is it possible that if A1=1 then put a timestamp of when the cell A1 went to 1 in B1 and the word "started" in cell c1. when cell A1 goes to 0 then put a timestamp of when A1 went to 0 in B2 then the word "stopped" in cell C2 and so on.

    I am trying to log uptime and downtime of a peice of equipment. What time the machine stopped and what time it started back 1=on 0=off.

    I hope that I am not being too much of a Nuisance. and Thank you all again for all your help!!!
    Marty Clevenger

  2. #12
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    There is some code I pasted in your duplicate post...
    Tom

  3. #13
    Board Regular
    Join Date
    Jan 2005
    Location
    Fresno, Ca
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have some code I know would do just what you want. I need to dig it up. let me know if you are still monitoring this forum and you still need it.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •