Re: Formating Time for calculation

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

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 11/03/04 

Date: Wed, 3 Nov 2004 09:06:33 -0500

format the cell as

00:00 

-- 
Regards,
Tom Ogilvy
"MariaL" <MariaL@discussions.microsoft.com> wrote in message
news:ECC8AE4C-6CF1-46F0-BCE2-59E7F5C995BC@microsoft.com...
> I am importing a text file that averages employee's time into a
spread***.
>  I am having problems calculating time because when I import this text
file
>  into the spread*** 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
>
Quantcast