Formating Time for calculation
 

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

Formating Time for calculation
 

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

Formating Time for calculation
 

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