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. On Sun, 06 Mar 2005 14:39:33 -0600, Fred Grant <[EMAIL PROTECTED]> wrote: > On Sun, 2005-03-06 at 13:42, David Daester wrote: > > That works if I have formatted as Time HH:MM:SS. But I have formatted as > > [HH]:MM > > Lets assume I have the time 34:12 in cell B11. When I now set in C11 > > "=HOUR(E11)" I get 10 in place of 23. > > > > > > > > > > > > On Sun, 06 Mar 2005 13:31:51 -0600, Peter Kupfer > > <[EMAIL PROTECTED]> wrote: > > > David Daester wrote: > > > > Hi there > > > > I don't know how I can do this. > > > > I have in calc a cell with is time-formated ( [hh]:mm). This have to be. > > > > Now I want to calc with this cell as a normal cell, prefered as seconds. > > > > > > > > I tryed with a new cell in the format [ss], but I can't calc like a > > > > normal cell where I put just numbers. > > > > > > > > An (maybe bad) example what I mean: I have my downloads-rate in the > > > > time of 10h 20min. I know how many MB I downloaded in the time. > > > > Know I want to know what is my average bandwith. > > > > > > Lets assume you have the time value 10:20:00 in cell B11. This cell has > > > to formatted as Time HH:MM:SS for my example to work. > > > > > > Then in cell E10 I enter "=HOUR(B11)*3600+MINUTE(B11)*60+SECOND(B11)". > > > This returns 37200, which should be the number of seconds. You can work > > > from there. > > > > > > HTH, > > > > > > -- > Try this: In another cell, =b2*24 and format as regular number. This > will give you elapsed time in decimal form. You can then convert to > seconds if needed. > > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
