On Sun, 06 Mar 2005 22:00:36 GMT, David Daester <[EMAIL PROTECTED]>
proffered, in : news:[EMAIL PROTECTED]:
I tried serveral things, also in MS-Excel. In MS-Excel I found the function day. This function give you the number of days. Example: You have 110:15 formatted with [HH]:MM in Cell A1. In Cell A2 you type "=DAY(A1)" and you will get 4. When I do the same in OO I get 3. Why 3 and not 4? Then: I put in A1 800:15. Then I get in A2 1. Why 1? I tried with the function MONTH, this function give me 2. Why now 2 and not 1?
Am I to stupid to understand this functions or what shall I now use? Everything less than 1day is now problem, everything with more than 1 day is not regular.
I don’t think that is what the DAY function in Calc is doing. From
the Ooo Helpfile: –––––––––––––––––––-
DAY Returns the day of given date value. The day is returned as an
integer between 1 and 31. You can also enter a negative date/time
value. Syntax
DAY(Number)
Number, as a time value, is a decimal, for which the day is to be
returned. Examples DAY(1) returns 31 (since OpenOffice.org starts counting at zero from
December 30, 1899) DAY(NOW()) returns the current day.
DAY(C4) returns 5 if the contents of C4 = 8/5/1901.
–––––––––––––––––––-
What interests me though is that, if I put 110:15 into cell A1,
formatted as HH:MM:SS, and then enter =(a1/24) into B1, the result
given is 0.19.
I’ve just found that if enter =(A1/1) in B1, the result is 4.59 –
the number of days in 110 hours.
That is because it uses a decimal time value to represent the says.
This brings me a rather simple solution to the problem.
In B2, I entered 34:12:00 formatted as [HH]:MM:SS, the in c2 I typed =b2*86400 (86400 = seconds in a day) and voila.
HTH.
-- Peter Kupfer OOo user since 'OO4 http://peschtra.tripod.com/open_office/ooo_front.htm
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
