+ Reply to Thread
Results 1 to 2 of 2

Calculate interval and mark it in another column

  1. #1
    Registered User
    Join Date
    08-20-2011
    Location
    Switzerlan, Zurich
    MS-Off Ver
    Excel 2010
    Posts
    1

    Calculate interval and mark it in another column

    Hello there,

    I need to calculate an interval. Therefore I take a point in time, subtract 2 seconds and add 10 seconds.

    e. g.: With a point in time of 8.5 I have an interval from 6.5 to 18.5 seconds.

    Now I need to mark this interval in another column. So with an interval from 6.5 to 18.5 it would look like:


    6.2
    6.7
    7.8
    13
    15.7
    18

    19


    What is the most efficient way to do this? How can I calculate the interval and mark the corresponding area?


    Thanking you in anticipation

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Calculate interval and mark it in another column

    Welcome to the Board.

    If we assume the values you listed are in A1:A7 and that in C1 you enter your "point in time" - eg 8.5 then we can highlight A1:A7 and apply a Conditional Format formula rule of:

    Please Login or Register  to view this content.

+ 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