Trying to use mode on data with negatives times.
<colgroup><col span="2"></colgroup><tbody>
</tbody>
-0:11 | #value ! |
-0:06 | #value ! |
-0:03 | #value ! |
-0:05 | #value ! |
0.01 | 0:08 |
0.00 | 0:00 |
0.00 | 0:01 |
The #value is removing the seconds if present formula [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]INT(CJ15*1440)/1440 I'm removing seconds as I thought it was affecting the mode function, but it in itself has the #value error. So, do you need to condition times before mode will work with positive and negative times data set? [/FONT] |
<colgroup><col span="2"></colgroup><tbody>
</tbody>