I had to copy and paste special to an other spreadsheet because for some reason that baffles me, I could not edit the formatting of your cells. I am sending you a spread sheet off-line that will do what I understand you to want. If someone else wants the spreadsheet then contact me directly.
Joe Conner, Poulsbo, WA USA

John Meyer wrote:
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

---------------------------------------------------------------------
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]

Reply via email to