A | B | Formula in N | Result of formula |
05/28/2019 05:15 | 05/28/2019 05:00 | =IF(A3="","",TEXT(TIMEVALUE(TEXT(A3,"HH:mm"))-TIMEVALUE(TEXT(B3,"HH:mm")),"hh:mm")) | 00:15 |
<tbody>
</tbody>
This has to be simple, and don't know why I'm unable to think of how to do this, but I need some help.
I've got dates and times in columns A and B, and a formula in N that calculates the difference of those 2 times. What I want is a formula that shows me the average difference in the last 20 rows. So, here's what my data looks like.