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]
