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]
