Forum Discussion

Zaphous's avatar
Zaphous
Copper Contributor
Mar 09, 2022
Solved

Pulling the start and end of time

Hi everyone! First time actually asking for help in excel.    So, I would like to end up with a starting time of when a cell contains the value 100 (found in column J) and the end time  when a cell...
  • Zaphous's avatar
    Mar 09, 2022

    Zaphous

    I actually figured it out myself if anyone reads this. I used this formula =IF(G2>G3,E2,IF(G2<G3,E2,"")) to tell me if G2->G3 is different than give me the cell in E2, otherwise give me a blank cell.

Resources