Time entry at speed

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Apologies if this message has come up before, I can't find
my post of yesterday.

I have to enter current time in an Ecell 2000 spreadsheet
cell for a number of events. These can occur quite close
together so typing them in isn't an option. I discovered
that CTRL + SHIFT + : (Colon) will enter the current time
but it seems it will only display as hh:mm. I checked the
cell format and it is set for hh:mm:ss. When I press
return to move on to the next entry, the hh:mm changes to
hh:mm:00. In other words, I cannot get it to display the
seconds.

Can anyone help? I seem to be close - but not close
enough!
 
You got 3 answers to your post yesterday, I'd suggest you get a newsreader
as opposed to using a web browser.. Do a goggle search on the name you used
yesterday. [Talltone]
 
If you're still there, I think you read more into Peo's post than he
intended--or at least more than I read into it.

I think that he was quite serious about getting a newsreader instead of using
MS's CDO interface. If you use these groups for any length of time, you'll find
that you'll waste a lot less time with a newsreader.

If you have Outlook Express installed, try clicking on these links (or copy and
paste into MSIE).

news://msnews.microsoft.com/microsoft.public.excel.setup
news://msnews.microsoft.com/microsoft.public.excel.misc
news://msnews.microsoft.com/microsoft.public.excel.worksheet.functions
news://msnews.microsoft.com/microsoft.public.excel.newusers
news://msnews.microsoft.com/microsoft.public.excel.programming

(You can always connect to more later)

Here are some links that explain it better:

Chip Pearson has some notes written by Leonard Meads at:
http://www.cpearson.com/excel/DirectConnect.htm

David McRitchie's notes at:
http://www.mvps.org/dmcritchie/excel/xlnews.htm
http://www.mvps.org/dmcritchie/excel/oe6.htm

Tushar Mehta's notes at:
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.htm

And if you're looking for old posts:

Or you can use google (maybe a few hours behind) to search for stuff you've
posted (and find the replies, too)

http://groups.google.com/advanced_group_search
http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100

Ron de Bruin has an excel addin that you may like:
http://www.rondebruin.nl/Google.htm
 
Back
Top