On Tue, 19 May 2009 12:56:29 -0600 Came this utterance formulated by John Meyer to my mailbox:
> BTW, here is the file that I am using: > > http://www.4shared.com/file/106447673/814de6c9/torrie.html > > I am trying to extract the hour from a cell and put it into a second > column, but when I use the HOUR() function all it returns is 12:00:00 > AM > In "Format - Cell" you can modify how this data looks using the format code. Your second cell only needs "=x1" (or the address of the first cell) as it's formula. -- Michael All shall be well, and all shall be well, and all manner of things shall be well - Julian of Norwich 1342 - 1416 --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org