On Thu, 2005-02-03 at 23:28 -0500, G. Roderick Singleton wrote: > On Fri, 2005-02-04 at 11:00 +0800, Mhac Janapin wrote: > > When entering consecutive numerical data, all i do is enter the first > > value in the first cell then drag the handle in the lower right corner > > of that initial cell to the next cell and all the way to the last > > value i want. In ascii: > > +---------+----------+ > > | 1 | 2 | --> works here > > +---------+----------+ > > | 2 | | > > +---------+---------+ > > also here | > > > > Now, is there a similar feature for time entries? I am making a > > schedule starting from 7:00 AM to 10:00 PM. Instead of typing > > everything, I was looking for a similar feature where I just put in 7 > > (format it as time hh:mm) and then click and drag all the way down to > > 10:00 pm. > > > > As it is now, in OpenOffice.org1.1.4 Calc's, everything becomes just > > 7:00pm. What gives?
<tip author="Jonathon Coombes" subject="Time sequences" category="Calc"> When you enter the times into the spreadsheet, you must enter them as time format. Simply create the first time as 7:00 then the next time as 8:00 and then select both and drag it to what time you need. The second cell tells the difference between the times that will be used. </tip> This will probably result in a format such as 07:00:00 which is the hours:minutes:seconds format. If you do not require the seconds, then simply format the cells to the appropriate time format afterwards. Regards Jonathon --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
