Please help with the formula with the following conditions:
- Look for the rightmost data in the J-O column
- Then the rightmost data is subtracted from column J
Example:
- In row 513, the rightmost data is in column L. So L513-J513 results 4:19:35
- In row 514, the rightmost data is in column M. So M514-J514 results 8:59:45
Thank You
I’ve tried searching on Google, chatgpt, gemini, etc. but haven’t succeeded either
New contributor
Halah Opoto is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.