Convert date/time to time only in Excel?

[Guest]

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?

 

[Trevor Shuttleworth]

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

 

[Peo Sjoblom]

Or

=MOD(C2,1)


--
Regards,

Peo Sjoblom

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

 

[David Biddulph]

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")

 

[Guest]

Awesome! Thanks so much.

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