Results 1 to 5 of 5

[SOLVED] Quick question: Time it takes to reach a temperature?

Threaded View

  1. #1
    Registered User
    Join Date
    06-07-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question [SOLVED] Quick question: Time it takes to reach a temperature?

    Hello! What a great forum, has helped me many times.

    I have two columns of data, D and E with time in the E column and rising temperatures in the D column.
    My question is that I would like to the find the time between when column D exceeds 30 and when it reaches a value like 150 by referencing the time column E.

    I solved this using the VLOOKUP function: =(VLOOKUP(150,D12:E400,2,TRUE))-(VLOOKUP(30,D12:E100,2,TRUE))
    However, I had to move my time variables from column C to E in order for VLOOKUP to work. (It won't accept a lookup value of -1 for the column designation)

    Is there another way to do this?

    Thank you in advance!
    Last edited by Romoko; 06-11-2012 at 01:01 PM.

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