Replies

You could use a batch file to start the program, and if it exits loop back and start it again. Something like the following untested batch:

@ECHO OFF
:LOOP
START /WAIT programname.EXE
GOTO LOOP

Then you must have to do something else like turn on “Active Desktop.” I have an NT 4.0 SP6 system that has had every IE from 4.0 to 5.5 installed and I don’t have the quick launch on the task bar.

It is hiding in Windows 98, ME, or 2000. It does not exist in NT.

It sounds like you are holding down the key too soon and this is creating an error in the Power On Self Test (POST) routines. Don’t press the key until the POST routines are almost complete.

Don: Date/Time in Excell are kept as the number of days since 12am 1/1/1900. Therefore, time is kept at the fractional part of one day (24 hours. Twelve hours = .5, six hours = .25, 3 hours = .125, etc. Therefore, you need to multiply the time by 24 to get the number of hours. If the time is in A1, and the rate is in A2, then the following formula should give you what you want:

=A1*24*A2

Make sure that the cell containing the time does not also contain a date. If it does, then you will need to use one of several methods to extract just the time that you want.

I see that you have gotten numerous attempts to solve this problem from others. We could probably go on like this and eventually find out exactly what is causing the problem. It would probably be something simple like having “Transition Formulas” selected in “Options.” However, it could take a long time to narrow it down this way.

I will suggest something that might get you working more quickly. Why not create a new workbook and copy the worksheet to the new workbook (everything but the column causing the problem). If the date entry then works in the new workbook, you can copy any other worksheets, VBA code, etc. to that workbook and delete the one that does not work.

If you want to sent the offending workbook to use to look at, then make a copy of it and delete all of the data. See if the problem still happens, and if it does send us the workbook (not directly to me as I no longer have Excel 97 available).