Re: Re: [OT] Mobile phone bills

["Paul Robinson" <ukcueman@xxxxxxxxxxx>]

Perhaps the original spreadsheet has a text string in hh:mm:ss format
rathe=
r than a number
that's got an excel format applied. That being the case, you might try a
fo=
rmula to
convert the text string to a number that you can work with.

Paul

----- Original Message -----=20
From: "darren_karp2001" <darren@xxxxxxx>
To: <ukha_d@xxxxxxx>
Sent: Friday, August 19, 2005 11:56 AM
Subject: [ukha_d] Re: [OT] Mobile phone bills


> 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 =3Dsum() formula.
> > Strangely if I use =3DE123+E124+E125,etc. it works. Any clues?
> >
> > TIA
> > Darren



=09
=09
=09=09
___________________________________________________________=20
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with
voicem=
ail http://uk.messenger.yahoo.com=0D