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

Hi NBAJ,

Assume your date/times are in A1:A100.

In B1 enter the formula:

=A1-INT(A1)

and drag down as far as required.

If required, you can format the formulae cells with a suitable time format
and convert the formulae to values via an Edit | Copy Edit | PasteSpecial |
Values operation.

If you need to autoate this, tutn on the macro recorder while you prerform
the operation manually. The resultant code may be edited to provide more
generic application. If you experience difficulty with such editing, post
back with the problematic code.


---
Regards,
Norman


"nbaj2k" wrote in
message ...

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

see your post under general questions.
FSt1

"nbaj2k" wrote:


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

You have an active thread in .misc.

nbaj2k wrote:

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

--

Dave Peterson

I apologize, to be totally honest I've been jumping around to different
things and realized that I posted it twice, I totally apologize.

~J


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