Convert date/time to time only in Excel?
 

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?

Convert date/time to time only 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?

Convert date/time to time only 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?

Convert date/time to time only 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?

Convert date/time to time only 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?