Re: [OT] Mobile phone bills

["darren_karp2001" <darren@xxxxxxxxx>]

Hi David,

Many thanks for the reply. I did try that and it still doesn't work.
Simply says 00:00:00 in the sum box.

Regards
Darren





--- In ukha_d@xxxxxxx, "David Irwin" <david@i...> wrote:
> 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
>
>
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor --------------------
~-->
> <font face=arial size=-1><a
>
href="http://us.ard.yahoo.com/SIG=12hdvivp9/M=362339.6886523.7841161.
2920218
> /D=groups/S=1705041992:TM/Y=YAHOO/EXP=1124384055/A=2894633/R=0/SIG=
10pkrq6ru
> /*http://www.drugfree.org";>Drug
Abuse Can Be Prevented "One of the
most
> effective drug prevention organizations" (NY
Times)</a>.</font>
> -------------------------------------------------------------------
-~->
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.338 / Virus Database: 267.10.12/75 - Release Date:
17/08/2005