New answers tagged worksheet-function
0
Figured it out... took me a while...
INDIRECT() has to be used around the entire reference. In order to achieve what I needed, the formula looked like this:
=INDIRECT("Sheet2!A"&A1)
0
Do you mean output like this!
Cell C1 shows correct averages.
If yes, set the cell format to 24 hours and use the Average for (Numbers)
For time Elapsed use simple subtraction = Cell B - Cell A
Top 50 recent answers are included
