HP Pentium, win 10,LibO 6.3;
a1=1,[num frmt] , b1=18:00,[time frmt], … repeated 6X.
How SELECT alternate cells[only time frmt] - for AVERAGE Formula ?
Not sure I understand what you want to do, but to edit the formula used in any cell first left-click on the cell. Then move the cursor to the Formula bar near the top of the window and click on the text of the formula appearing there. You can change the range of the data, the function, anything you like. Be sure to hit Enter when you are done, in order to exit edit mode.
You’ll only understand 0.01% of abi’s questions anyway and s/he never bothers to write comprehensible questions even after having been asked for a dozen times. Just ignore if you don’t get it at the first grasp.
Simple answer : =AVERAGE(B1,B3,B5)
or =AVERAGE(B2,B4,B6)
Probably not what you want.
Or may be =AVERAGE(B1;D1;F1;H1;J1;L1), the same that =AVERAGE(B2~D2~F2~H2~J2~L2).
LibreOffice 6.3.6.2.