See Pic 2 below.
I want my 'Hourly Wage' (R3) based on total 'Profit/Loss' (P3) divided by 'Total Time' (Q3). I want it to update automatically when I enter new data in to column I and L.
P3 has formula =INDEX(L4:L101,COUNT(L4:L101))-L4 formatted as Currency.
Q3 has formula =SUM(I5:I54) formatted as Time.
Column I is formatted as Time. Column L is formatted as Currency.