> >> AcctSessionTime Hours online Minutes Billed Billed Expected
> >> 137,964 38.32 1509
> 25.15 23.32
> >> 150,389 41.77 0
> 0 26.77
> >> 165,530 45.98 1339
> 22.32 30.98
> >> 1,176,051 326.68 8061
> 134.35 311.68
>
> Dale E. Reed Jr. wrote:
>
> > Emerald rounds each call to your defined interval. Therefore, you
> can't simply sum the AcctSessionTime
> > values, or you will be under what Emerald calculates (Most likely by
> the number of calls).
> > How did you derive the above numbers? Are they from the Call History
> table, or a query you ran?
>
> I got the acctsessiontime from the calls table into an excel
> spreadsheet.
> Hours Online = AcctSessionTime / 3600
> Minutes Billed = from the callhistory table
>
> The CallHistory contains the following entries for the records shown
> above. I have added the AcctSessionTime from the Calls table.
>
> AccountID StartDate Months Mins
> Calls ChargeID AcctSessionTime
> ----------- --------------------------- ----------- -----------
> --------- ----------- -----------------
> 992 Jul 22 1999 12:00AM 1 1509
> 159 1408 137,964
> 1664 Jul 14 1999 7:58PM 1
> 675 29 (null) 150,389
> 2634 Jul 14 1999 7:58PM 1 1339
> 55 1456 165,530
> 3383 Jul 18 1999 12:00AM 1 8061
> 342 1518 1,176,051
>
> Since Emerald rounds off each call to the defined interval, I suppose
> I'm losing &/or gaining some time in the process. A smaller interval
> will give more accurate figures?
> If the interval is 3600 seconds, how will it round off the figures
> listed below? I didn't quite understand how it works.
>
> acctsessiontime
> ----------------
> 37
> 145
> 387
> 1355
> 535
> 2459
> 1468
>
> Regards
>
> Annabel
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart