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]
