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, > > -- > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
