Hi!

What does 105306 represent?

10 hrs 53 mins 06 secs
10:53:06 AM
10:53:06 PM

Are all the strings 6 digits?

Can you provide more samples?

Biff

"Ade" wrote in message
...
Hi there
I'm an inexperienced excel user but have been given a task to present some
raw data spewed out from a telephone exchange to a note pad file into an
excel spreadsheet. From the outset I've had difficulty in transferring the
data over but have been following the help files provided by office online
and have, up until now, muddled through. My latest problem has had me
tearing my hair out for the last four hours or so. Notepad gives me a six
digit figure eg 105306 which is the time mark for an event ie 10:53 and 6
secs. How can I use this 6 digit figure to generate a time format within a
cell in excel? Every time I try to format the cell it just gives me
nonsense output, something like 00:00:00.
I'm pretty sure it's a boneheaded question for some of you experts but can
anybody give me a clue?
Thanks in advance
Adrian