entering time data

[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

 

[Anne Troy]

It looks like you could use this code if you alter it:
http://www.ozgrid.com/VBA/mask-time-input.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

 

[Bob Phillips]

See Chip's page at http://www.cpearson.com/excel/DateTimeEntry.htm

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)