
Figure 173: Raw data in Calc
Solution with a matrix formula
To calculate the frequency you have to create 24 classes, one for each
hour. In the next column you enter the number of emails with the
function FREQUENCY.
Figure 174: FREQUENCY function
in a matrix formula
236 OpenOffice.org 3.x Calc Guide