I am importing a text file that averages employee's time into a spreadsheet.
I am having problems calculating time because when I import this text file
into the spreadsheet and it is < 1:00 it imports without the leading 0
(example as :59 instead of 0:59) which is needed to do time calculations.
Right now I have to add the zero in front of the colon manually. Does any
one know of a way to do this with a formula or programmatically?
Also, (since this has already been suggested), I cant do
Edit|replace
what: : (just a single colon)
with: 0: (zero followed by a colon)

Because 1:29 becomes 10:290:00 AM €“ and I cant do a calculation using this
format

Thanks,

Maria

When you import as text it should retain the leading zero.
It does with me anyhow.

RBS

"MariaL" wrote in message
...
I am importing a text file that averages employee's time into a
spreadsheet.
I am having problems calculating time because when I import this text file
into the spreadsheet and it is < 1:00 it imports without the leading 0
(example as :59 instead of 0:59) which is needed to do time
calculations.
Right now I have to add the zero in front of the colon manually. Does
any
one know of a way to do this with a formula or programmatically?
Also, (since this has already been suggested), I cant do
Edit|replace
what: : (just a single colon)
with: 0: (zero followed by a colon)

Because 1:29 becomes 10:290:00 AM €“ and I cant do a calculation using
this
format

Thanks,

Maria

format the cell as

00:00

--
Regards,
Tom Ogilvy

"MariaL" wrote in message
...
I am importing a text file that averages employee's time into a
spreadsheet.
I am having problems calculating time because when I import this text
file
into the spreadsheet and it is < 1:00 it imports without the leading 0
(example as :59 instead of 0:59) which is needed to do time
calculations.
Right now I have to add the zero in front of the colon manually. Does
any
one know of a way to do this with a formula or programmatically?
Also, (since this has already been suggested), I can't do
Edit|replace
what: : (just a single colon)
with: 0: (zero followed by a colon)

Because 1:29 becomes 10:290:00 AM - and I can't do a calculation using
this
format

Thanks,

Maria