Excel time issue, confirm please ?
Posted by Juan Pablo G. on January 30, 2002 6:52 AM
If you try to enter time 9999:00 (9999 hours), Excel accepts it perfectly, but, try to increase one hour by entering manually, that is 10000:00 and it won't, recgonizes it a Text. However, it works doing a formula ="9999:00" + (1/24).
Won't work either If i try to fool it by entering
Haven't tried this in 2000 or XP, only 97, but can you confirm, please ?
Juan Pablo G.