Workaround for the "TIME BUG" In Microsoft Excel
This question was answered on June 15, 1999. Much of the information contained herein may have changed since posting.
In Microsoft Excel, entering a time with more than 60 minutes into a cell may change the cell over to the General number format and give you a decimal number
If you type: 5:62, the cell will pop up with 0.251389 Try entering THAT into your date book! These versions of Excel are affected: Excel 97 for Windows; Excel for Windows 95, versions 7.0 and 7.0a; Excel for Windows, versions 5.0, 5.0a and 5.0c
Microsoft's workaround: Change the cell to the Time number format by highlighting the cell, going to Format, Cells, Number, and clicking Time in the Category list Then hit the time format you want in the Type list, and choose OK
About the author
Posted by Ken Colburn of Data Doctors on June 15, 1999
Need Help with this Issue?
We help people with technology! It's what we do.
Contact or Schedule an Appointment with a location for help!