Convert date/time to time only in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

=MOD(C2,1)


--
Regards,

Peo Sjoblom



Trevor Shuttleworth said:
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
Click to expand...
 
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")
 
Awesome! Thanks so much.

Trevor Shuttleworth said:
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
Click to expand...
 
Back
Top