Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I.E. 01/07/2011 09:30 I would like to extract 09:30 of this cell.

How I can do it

share|improve this question
up vote 1 down vote accepted

Try =TEXT(cell, "hh:mm") (function help).

share|improve this answer

If you want to keep it as a numeric value, so you can use it for calculations

=mod(A1,1)

Format as time.

share|improve this answer

Or use

=TIME(HOUR(A1),MINUTE(A1),SECOND(A1))

This will be formatted as a time value automatically.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .