Re: Adding durations/phone bill

Tech-Archive recommends: Fix windows errors by optimizing your registry

Have been off-line for a while - looks like Ian has sorted it out.
Basically, the data is text (in an Excel file), so it has to be
converted into date format for his SUM to work.

Pete

On Nov 26, 10:50 pm, "Sandy Mann" <sandyma...@xxxxxxxxxxxxxx> wrote:
Speaking personally, no offence taken, I just thought that you stood a
better chance of getting an answer from pet because he had actually done
what you were trying to do.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandyma...@xxxxxxxxxxxxxx
Replace @mailinator.com with @tiscali.co.uk

"Ian" <i...@xxxxxxxxxxxxxxxxxxxxx> wrote in message

news:fifh50$oi5$1$8300dec7@xxxxxxxxxxxxxxxxxxx



Oh god hope I haven't caused offence. All input appreciated!
Tried the alt 0160 same problem. I only mention this to keep "the across
this" informed.
I don't know my ctrl from my alt!
Many thanks to all
sorted in it!
Cheers

"Sandy Mann" <sandyma...@xxxxxxxxxxxxxx> wrote in message
news:u%23WGitGMIHA.5328@xxxxxxxxxxxxxxxxxxxxxxx
Hi Pete,

I'm a bit lost here now, I don't know if Ian was replying to you or me.
As you have experience of downloading Vodafone data I will bow out and
leave you to help Ian,

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandyma...@xxxxxxxxxxxxxx
Replace @mailinator.com with @tiscali.co.uk

"Pete_UK" <pashu...@xxxxxxxxxxx> wrote in message
news:3be50d04-3cd0-439a-bb0e-f6c7a666c75e@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Just continuing with this, then, a non-formula approach is to
highlight the column of data, then CTRL-H (Find & Replace) -

Find What : (i.e. colon)
Replace With : (also a colon)

Click Replace All.

Hope this helps.

Pete

On Nov 26, 7:52 pm, "Ian" <i...@xxxxxxxxxxxxxxxxxxxxx> wrote:
Just took a small sample and over wrote the colons. It works but can't
do
that for the whole doc.

"Ian" <i...@xxxxxxxxxxxxxxxxxxxxx> wrote in message

news:fif6a6$snt$1$830fa79d@xxxxxxxxxxxxxxxxxxx

Tried that get :- "MS excel cannot find matching data to replace. No
cell
in the selection contains what you typed, or no records match the
criteria".
I did see the numerals entered and I'm using Num lock on a
laptop....Just
in case that means something.
Cheers me dears.

"Sandy Mann" <sandyma...@xxxxxxxxxxxxxx> wrote in message
news:O$GTG2FMIHA.4808@xxxxxxxxxxxxxxxxxxxxxxx
I always suspect that downloaded data contains non-breaking spaces
character 160. Try highlighting the data and the selecting Edit >
Replace. In Find What: enter 0160 from the number pad NOT the
numbers
over the letter keys. (you will not see anything entered in the
dialog box
because it is a space.) Leave the Replace with empty and select
Replace
all. If that does not correct the problem then Then do the same but
use a
space instead of 0160

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandyma...@xxxxxxxxxxxxxx
Replace @mailinator.com with @tiscali.co.uk

"Ian" <i...@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:fif33n$mc9$1$8302bc10@xxxxxxxxxxxxxxxxxxx
Hi
I'm trying to add the durations on my phone bill (yes it was a
biggie!!).
Tried various things including formatting the cells to custom
hh:mm:ss.
High light a cell, click sigma, select range of cells, enter.
00:00:00
everytime.
I'm using excel '97 that comes with office pro '97 or something
like
that.
The original file was downloaded from Vodafone as an excel and is
colon
separated.
Any ideas? Any other aplications I could paste into that would do
it?
Cheers me dears
BB- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

.

Relevant Pages

  • More Help Needed..please
    ... By the way, if for some reason you ever select a cell in column A, the above ... I was going to use both Worksheet_Change & Workbook_Open in an Excel file ... "CNine" is in the same row as the ActiveCell, but always one column to the ...
    (microsoft.public.excel.programming)
  • Re: Activating a specific excel file
    ... The following macro accesses cells in an Excel file. ... Dim fileName As String ... By clicking a userdefined paste button de value of a second cell in the ...
    (microsoft.public.word.vba.general)
  • Re: Activating a specific excel file
    ... The following macro accesses cells in an Excel file. ... Dim fileName As String ... By clicking a userdefined paste button de value of a second cell in the ...
    (microsoft.public.word.vba.general)
  • Re: running a macro on every refresh of the screen
    ... Does this work when a cell is paste linked to another ... excel file and that file changes, ... >shovit sahai wrote: ...
    (microsoft.public.excel.programming)
  • Re: Printing wrapped cell not WYSIWYG
    ... Ian S wrote: ... The text to the left of the cell is hidden. ... > problem only occurred for files transfered from Excel for Windows. ... as said, this is just a clue, let us know if it points you out... ...
    (microsoft.public.mac.office.excel)