boilerplate: ///\\\ Snippets for use as boilerplate: ///\\\ -------------------------------------------------------------------------------------------- Please consider using newsgroups, where you will likely get the quickest and most reliable replies. http://www.mvps.org/dmcritchie/excel/xlnews.htm -------------------------------------------------------------------------------------------- A question such as yours would best be asked in *one* of the newsgroups Be sure to post only in text not in HTML or MIME and without attachments. General Topics or not sure which newsgroup news://msnews.microsoft.com/microsoft.public.excel.misc Programming newsgroup (Macros, and User Defined Functions) news://msnews.microsoft.com/microsoft.public.excel.programming Worksheet Functions builtin functions i.e. VLOOKUP Worksheet Function news://msnews.microsoft.com/microsoft.public.excel.worksheet.functions Hints for New Posters http://www.cpearson.com/excel/newposte.htm -------------------------------------------------------------------------------------------- ==================================================== If you don't know about the fill handle it is the little bulge near the lower right corner of a selection (i.e. selected cell). See HELP or see http://www.mvps.org/dmcritchie/excel/fillhand.htm ==================================================== Please post questions to newsgroups unless you have corrections or questions about specific webpage content. I believe the MVP page indicates to use the newsgroups, but I don't know which page you referred to. ================================================== Generally questions directed at newsgroups get a lot quicker answer; and since others see them, questions to a newsgroup tend to end up with the best answers, because they are looked over by many people. The misc group (General Topics) . news://msnews.microsoft.com/microsoft.public.excel.misc gets read by everyone. If I think I can answer your question later and run into difficulty with anything, including time, you could be waiting a long while. Once you are familiar with the groups you might post to a different group instead, but only post a question to one group. Had you posted to a newsgroup perhaps 100 people may have been helped instead of just one. Hints for New Posters http://www.cpearson.com/excel/newposte.htm Please take a look at http://www.mvps.org/dmcritchie/excel/xlnews.htm http://www.mvps.org/dmcritchie/excel/posting.htm You will find that most question have already been asked and can be found in the Google Usenet Archives. ==================================================== You can ask for an email copy, but do not count on an courtesy email copy, and certainly not an email copy instead of a newsgroup response. Some people will refuse to even provide an email copy, just to make sure that all conversation remains with the group so everyone benefits. Reading the following may help with postings. Hints for New Posters http://www.cpearson.com/excel/newposte.htm. ==================================================== Thank You: If the answer is obvious -- no conflicting answers an email would be an alternative way to provide a Thank You. If you are tempted to ask an additional question with the Thank You, stick to the thread (same subject) or post a new question so others also benefit.. Outlook Express: Since you are using Outlook Express, it might be useful to create rule and a view to spot your own postings, select your post, then switch from "Hide Read Messages" to "Show All Messages" to help see the entire thread. More information on OE5 and OE6 http://www.mvps.org/dmcritchie/excel/oe6.htm --not used yet--- My own opinion is that a Real-Time clock does not belong on an Excel page you are consuming resources in an application not designed for that purpose. It would take away fewer cycles from your machine to get a free clock for your System Tray, or to use an clock in an HTML page that looks at your own PC clock. However you will find a real-time clock here for Excel http://www.mvps.org/dmcritchie/excel/excel.htm and a lot more date and time information including a link to: Clocks in System Tray and related downloads See Ziff-Davis site http://www.zdnet.com/downloads/allhot/hotfree.html look for TClockEx v1.4.2 -- to see seconds, date and more in tray clock TClockEx - Taskbar Clock Enhancer by Dale Nurden at his site. popup: System: 68% 1,136kB free, systray:Fri, 11 Feb 2000 - 20:53:04 ======================================================= Display Negative Time: Searching the Google Groups Archives http://groups.google.com/advanced_group_search?q=group:*Excel* search: "display negative time" group:*Excel* You would have to show time in hours and format as general =(B2-B1)*24 format as General or use the 1904 date system (Tools, Options, Calculation, 1904 ....) The option applies on a per file basis, but you will have to convert an existing files dates if you switch that file. see Tom Ogilvy's reply to a similar question http://google.com/groups?selm=eSecsSer%24GA.271%40cppssbbsa02.microsoft.com The above link may wrap in a reply or forward but you should see it on one line when I send it. ----------------------------------------------------- PLEASE, please, in the future use a subject that describes your request so that people looking for answers or wanting to provide better answers know what the actual subject is. Single word subjects, and the words "simple", "problem", "urgent", "Excel", as well as those that repeat words that are part of the newsgroup name do not describe the problem. You could of course search the newsgroup archives yourself for answers and you would tend to look at items that have descriptive subjects, and a portion of text that best matches what you want to find out about. http://www.mvps.org/dmcritchie/excel/xlnews.htm ----------------------------------------------------------- It would be most helpful if when you post a question you used a subject that describes the question. You should try to find your own answers by searching Google Newsgroups before posting. By including a more descriptive subject others who search the groups after you may find their answers without having to post. There are probably over 2000 postings per day during the work week in the programming newsgroup. http://www.mvps.org/dmcritchie/excel/xlnews.htm ---