I was wondering if this was possible, it's been haunting me for awhile
now. I had a topic that a couple people helped me with just yesterday
and I'm very greatful for that. I have returned once again for
hopefully just a little more guidance.

I'm exporting data into a spreadsheet. There is a "created" column in
which the cells include dates and times, and example of the contents of
a cell is this "7/14/2006 1:49:03 PM"

If you go to cell formatting, you can change it all you want, but the
contents of the actual cell stay the same, what you see just changes.
An example is if I pick 'h:mm' it will show the hours and minutes if
you just look at the cell, but if you click on it to see its contents
it still says 7/14/2006 1:49:03 PM.

Right now I have put parameters in a query and have 2 different boxes
you can type in for date range. There is nothing here that I can pull
just the time in and put in more parameters for that, which would
workout a lot better.

I'm trying to eventually make 2 boxes, one for start time and one for
end time in the end, but I just wanted to see if I could first grab
certain data from a cell and put it in another column of just "Time"
without having the date values in the cell along with it

Just wondering if it is possible to do. Although I realize that with
Excel, with the right coding, anything is possible!

Any help would be great, thanks!

~J


--
nbaj2k
------------------------------------------------------------------------
nbaj2k's Profile: http://www.excelforum.com/member.php...o&userid=36480
View this thread: http://www.excelforum.com/showthread...hreadid=563769