...
- The actual values stored in the raw data are the times in microseconds.
- The time in seconds is used to display a hours:minutes:seconds value in a report
- This is determined calculated when the report is generated by rounding the microseconds value divided by 1000000 (the number of microseconds in one second)
- The sums at the bottom are calculated in the report, by summing up the relevant column.
...
As you can see, one second has gone missing, although the sum is sums are numerically correct.
| Info |
|---|
So where did it go?
|
An alternative could be displaying to get the sum of the number of seconds from the sum of the microseconds (which is correct) and display the following:
| Status | Time in Status in Microseconds | Time in Status in Seconds |
|---|---|---|
| Status 1 | 41,570,259,033 | 41570 |
| Status 2 | 162,338,287 | 162 |
| Status 3 | 68,047,410 | 68 |
| Status 4 | 258,951,950 | 259 |
| Status 5 | 314,248,890 | 314 |
| Status 6 | 44,026,154,430 | 44026 |
| SUM | 86,400,000,000 | 86400 |
...
However, astute readers will note that 41570 + 162 + 68 + 259 + 314 + 44026 does not in fact equal 86400.
| Info |
|---|
So what to do? Unfortunately, this is called the rounding paradox. The simple fact of the matter is there is no nice way to deal with this.
We here at jtel have decided just to live with it - so sometimes the sums in our reports, when they involve times, may not add up as you would expect. Now, at least you know why! |
...