cancel
Showing results for 
Search instead for 
Did you mean: 

Calculating total monthly duration of calls

FIXED
dave4jazz
Dabbler
Posts: 24
Thanks: 4
Fixes: 1
Registered: ‎28-08-2018

Calculating total monthly duration of calls

I want to calculate what the total call time duration is for each calendar month.

I know you can download .cvs files for monthly billed and unbilled calls but I don't understand what the difference is.

How can I do it?

 

4 REPLIES 4
jab1
Legend
Posts: 17,111
Thanks: 5,493
Fixes: 255
Registered: ‎24-02-2012

Re: Calculating total monthly duration of calls

@dave4jazz Your call durations (and costs) - excluding those to 0800 numbers - are detailed on your monthly invoice. Unbilled ones are those made after your invoice is prepared, and will be detailed on the next one. Can you not work from that?

John
dave4jazz
Dabbler
Posts: 24
Thanks: 4
Fixes: 1
Registered: ‎28-08-2018

Re: Calculating total monthly duration of calls

Fix

You have confirmed what I thought.

I'll work with the billed data to calculate the average total monthly duration of my calls.

Thanks for the feedback.

 

RobPN
Seasoned Hero
Posts: 5,114
Thanks: 2,677
Fixes: 13
Registered: ‎17-05-2013

Re: Calculating total monthly duration of calls

@dave4jazz 

I've never seen a PN phone bill, but can't you just open the downloaded file in a spreadsheet and total the call duration column?

dave4jazz
Dabbler
Posts: 24
Thanks: 4
Fixes: 1
Registered: ‎28-08-2018

Re: Calculating total monthly duration of calls

You're right.

That's what I said in my original post. I'll download the .cvs file and create a spreadsheet to calculate the totals.

Thanks for the feedback.