I received a file with date/time stamp information in a field. When I pull
this information into Access, the queries that I have written won't work
because the date is attached to the time. How can I convert that date/time
value to time only value in Excel?

If the date were in cell C2:

=C2-INT(C2)

would give you just the time element

You could Copy and PasteSpecial | Values over the original, if required

Regards

Trevor


"Gretchen" wrote in message
...
I received a file with date/time stamp information in a field. When I pull
this information into Access, the queries that I have written won't work
because the date is attached to the time. How can I convert that
date/time
value to time only value in Excel?

Or

=MOD(C2,1)


--
Regards,

Peo Sjoblom



"Trevor Shuttleworth" wrote in message
...
If the date were in cell C2:

=C2-INT(C2)

would give you just the time element

You could Copy and PasteSpecial | Values over the original, if required

Regards

Trevor


"Gretchen" wrote in message
...
I received a file with date/time stamp information in a field. When I
pull
this information into Access, the queries that I have written won't work
because the date is attached to the time. How can I convert that
date/time
value to time only value in Excel?

Awesome! Thanks so much.

"Trevor Shuttleworth" wrote:

If the date were in cell C2:

=C2-INT(C2)

would give you just the time element

You could Copy and PasteSpecial | Values over the original, if required

Regards

Trevor


"Gretchen" wrote in message
...
I received a file with date/time stamp information in a field. When I pull
this information into Access, the queries that I have written won't work
because the date is attached to the time. How can I convert that
date/time
value to time only value in Excel?

I assume that when you pull it into Access you may want a text
representation, not Excel's time representation, so for 6pm you want 18:00,
not 0.75?
In that case =TEXT(A1,"hh:mm")
--
David Biddulph

"Gretchen" wrote in message
...
I received a file with date/time stamp information in a field. When I pull
this information into Access, the queries that I have written won't work
because the date is attached to the time. How can I convert that
date/time
value to time only value in Excel?