time data

N

nick carriero

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
 
B

Bob Phillips

Response in public.excel

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top