Is there any reasonable explanation in technique? Or is it a bug? 在 2009-10-14三的 17:48 +0800，Zhu Lihua写道： > Hi all, > > There is a time format: [HH]:mm:ss > > I found it has a value scope from -49710 to 49710, which means from > Nov/23/1763 00:00:00 to Feb/6/2036 00:00:00. But this format show hour > value as hours passed since Dec/30/1899, So it's value is 1193040:00:00. > > Input 49711 with this time format will display "###" in the cell. I > guess it must be out side of the permitted scope. But why it has this > limitation? I guess it must have something to do with the storage of the > time in the memory. I wonder how it stored? and why it has this > limitation? Could anyone give me some hint? > > Thanks and best regards, -- Lihua
北京红旗贰仟软件技术有限公司 Beijing Redflag 2000 Software Co., Ltd. Building No.2, Block A, Huilongsen, 18 Xihuan Nanlu Beijing Economic-Technological Development Area Beijing - P.R.China Tel：+86-10-51570010 ext.6141 http://www.RedOffice.com --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
