The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Message Prev][Message Next][Thread Prev][Thread Next][Message Index][Thread Index]

RE: [OT] Mobile phone bills


  • Subject: RE: [OT] Mobile phone bills
  • From: "David Irwin" <david@xxxxxxxxxxxxxxxx>
  • Date: Thu, 18 Aug 2005 21:43:16 +0100

Darren,
This may well be due to Excel not thinking the cells are in the same
format.
To resolve this, highlight the column (or all the time cells) and press
Ctrl+1. On the Number tab select Custom as the category and enter hh:mm:ss
in the type field.
Having done this the Sum() should work.

Dave

-----Original Message-----
From: ukha_d@xxxxxxx [mailto:ukha_d@xxxxxxx] On Behalf Of
darren_karp2001
Sent: 18 August 2005 10:41
To: ukha_d@xxxxxxx
Subject: [ukha_d] [OT] Mobile phone bills

Hi All,

I have downloaded an Excel file from carphonewarehouse to calculate my call
costs,etc. as I am going to be moving from vodafone to easymobile.com
(great
rates BTW) and surprise surprise there isn't a total duration spent!

The call durations are in HH:MM:SS format and I cannot seem to get Excel
2003 to add up the entire column using the =sum() formula.
Strangely if I use =E123+E124+E125,etc. it works. Any clues?

TIA
Darren







UKHA_D Main Index | UKHA_D Thread Index | UKHA_D Home | Archives Home

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.