+ Reply to Thread
Results 1 to 4 of 4

3 different times

  1. #1
    Registered User
    Join Date
    01-05-2010
    Location
    nj
    MS-Off Ver
    Excel 2003
    Posts
    10

    3 different times

    I have to go through logs all day and line up three different time sources.
    If I could change one of the times, and have the other two change accordingly , my life would be so much better.

    Please help !
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor tlafferty's Avatar
    Join Date
    04-08-2011
    Location
    United States, Tacoma, WA
    MS-Off Ver
    Excel 2010, Excel 2013 Customer Preview
    Posts
    1,112

    Re: 3 different times

    What do you want the times to do when you make a change?

  3. #3
    Registered User
    Join Date
    01-05-2010
    Location
    nj
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: 3 different times

    if I change any of the times, I would like the other 2 to change. IE if one cahnges by 7 minutes, I would like all 3 to display the additional 7 minutes

  4. #4
    Registered User
    Join Date
    01-05-2010
    Location
    nj
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: 3 different times

    What I have is 3 different machines that all have their Time of day set to different values.
    When I start analyzing problems , the first thing I need to do if figure out the time difference between all 3 servers. So what I do is write down the time of all 3 servers at a known point in time. I then have to look through the logs from all three servers that display their own time in their logs. What I am looking for is a way to input the time of server A in A1, the Time of Server B in B1, and the time of server C in C1. Then if I change the value of the time in A1, I would like the time to change in B1 and C1 to match the time difference, so they are all showing the same point in time. And same for B1 and C1, If I change any one of the times, I want the other 2 to line up.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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