Hi,
There is a time format: [HH]:mm:ss
this time format allows to count hours > 24 hours A1 03:00 A2 23:00 A3 =sum(a1:a2) ==> 02:00:00 if you format A3 as [HH]:mm:ss then A3 gives 26:00:00 (26 hours)
I found it has a value scope from -49710 to 49710, which means from
the value scope must be higher because I can create a date of 2036-10-10 having the date value of 49958
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.
the default value for the zero point for date values is 1899-12-30. Calc can handle both negative and positive values for a date value. For the value -1 Calc would display 1899-12-29. The default value can be changed (in /tools/options/calc/calculate) to 1900-1-1 (to be compatible to StarCalc 1.0 documents) and to 1904-1-1 to stay compatible to older Excel documents.
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?
change the cell width. The value just doesn't fit into the cell boundaries. Kind regards, Joost --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
