We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 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!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
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
- 354.4K Banking & Borrowing
- 254.4K Reduce Debt & Boost Income
- 455.4K Spending & Discounts
- 247.3K Work, Benefits & Business
- 604K Mortgages, Homes & Bills
- 178.4K Life & Family
- 261.5K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards