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. -- noho ora mai, ka kite ano http://maxqnzs.com/References.html --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
