Calculating total monthly duration of calls
FIXED- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Help with my Plusnet services
- :
- Home Phone
- :
- Calculating total monthly duration of calls
28-06-2022 5:38 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
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?
Fixed! Go to the fix.
Re: Calculating total monthly duration of calls
28-06-2022 5:56 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
@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?
28-06-2022 6:15 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
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.
Re: Calculating total monthly duration of calls
28-06-2022 6:57 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
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?
Re: Calculating total monthly duration of calls
28-06-2022 7:11 PM - edited 28-06-2022 7:13 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
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.
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Help with my Plusnet services
- :
- Home Phone
- :
- Calculating total monthly duration of calls