0
324
ViewsExcel formula to compute the time Of "Logoff" record and its nearest "Logon" record above
I would like to have a 3rd column that only shows the time duration if the 2nd column value is "PC LogOff". The time duration will get the 1st instance of "PC LogOn" before the "PC LogOff" occurred. Is this possible in Excel?
·
Santiago Trujillo
2 answers
Answer question0
XLOOKUP() will give you desired result.
=IF(B1="PC LogOf",A1-XLOOKUP("PC LogOn",$B$1:$B1,$A$1:$A1,0,0,-1),"")
·
Santiago Trujillo
Report
0
If you don't have XLOOKUP, in C2 put =IF(B2="PC LogOn",A2,C1) and drag down, with C1 being just =A1.
Then in D1 put =IF(B1="PC LogOff",A1-C1,"") and drag down.
·
Santiago Trujillo
Report
Answer question