software

is there a way to enter minute second data e.g., 30:43 without having to
enter the hour (none of the data points are over 59 minutes duration) ----
i'm using the format [h]:mm:ss (since i want to add the values and the total
will exceed several hours) --- it seems to require an entry of the form
0:30:43 in order for the cell to contain the correct value ---- is there a
way to avoid entering the colons altogether

thanx

nick carriero
Response in public.excel

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;nick carrieroquot; gt; wrote in message
. ..
gt; is there a way to enter minute second data e.g., 30:43 without having to
gt; enter the hour (none of the data points are over 59 minutes duration) ----
gt; i'm using the format [h]:mm:ss (since i want to add the values and the
total
gt; will exceed several hours) --- it seems to require an entry of the form
gt; 0:30:43 in order for the cell to contain the correct value ---- is there a
gt; way to avoid entering the colons altogether
gt;
gt; thanx
gt;
gt; nick carriero
gt;
gt;