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?
|