We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
📨 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
Posts: 2,452 Forumite


in Phones & TV
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?
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?
0
This discussion has been closed.
Confirm your email address to Create Threads and Reply

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