 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2006entering time data
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 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 > 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) ---- [quoted text clipped - 6 lines] > > nick carriero See Chip's page at http://www.cpearson.com/excel/DateTimeEntry.htm -- HTH Bob Phillips (remove nothere from the email address if mailing direct) > 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) ---- [quoted text clipped - 6 lines] > > nick carriero |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.