>> I knew that I was using the wrong term, but what I meant was: "a way >> to tell the computer that an integer [0,23] should be read as >> belonging to the hour". >> > > If [0,23] means two integers 0 and 23 to be read as hours and minutes: > A1: 0 > B1: 23 > other cell, formatted as time: =A1/24+B1/1440 >
No, [0,23] means "all whole numbers from zero to twenty-three inclusive". It is a standard mathematical shortcut, I apologize for assuming that the list would be familiar with it. Actually, I have two errors in here, but if there are no mathematicians present then I won't bother correcting them! > Anyway, I always recommend to NOT store any lists of constant values within > a spreadsheet. Always try to store lists of data in some type of > (networkable/multi-user/rlational/scalable) database and use the very same > data in all your office documents and many other applications able to read > from your database. > This is not a list of constant data. It is a spreadsheet for recording the start and leaving times of volunteers for an organization. I know that one could argue the case of using Base instead of Calc for this, but that argument could be used for most Calc usage and in fact after some deliberation I came to the conclusion that Calc is more appropriate in this specific case. I am familiar with MySQL and thus databases in general, so I assure you that in this narrow case using Calc was the correct design decision. > Simple, flat database table used in a spreadsheet: > http://user.services.openoffice.org/en/forum/viewtopic.php?t=21099&p=96427#p96427 > (input form, user defined filter form, data pilot, free of macro code) This is a great link and I will make use of it in the future. Thanks! -- Dotan Cohen http://what-is-what.com http://gibberish.co.il --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
