📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

BT's duration of calls is crazy to analyse.

oldwiring
oldwiring Posts: 2,452 Forumite
Part of the Furniture 1,000 Posts Name Dropper
I have just dropped recent calls in to Excel to assist in some analysis I am doing as my contract comes up for renwal and for the autumn revisions. Their formatting of the data seems completely off the planet.

Firstly, if one looks behind what appears in print as minutes: seconds, the formatting is for hh:mm:ss, so what is seen as mm:ss is calculable as hh:mm. Confusable but it can be dealt with.

However, if any call gets in to free time, it really is super crazy. A call of 23 minutes chargeble duration appears in print as
26:27:00 and in the background as 01/01/1900 02:27:00.

All completely confusing ?on purpose perhaps?.

Can the BT man throw any light how to get those ridiculous figures in to a sensible form?
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 351.4K Banking & Borrowing
  • 253.3K Reduce Debt & Boost Income
  • 453.8K Spending & Discounts
  • 244.4K Work, Benefits & Business
  • 599.7K Mortgages, Homes & Bills
  • 177.2K Life & Family
  • 258K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.2K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.