How to extract the time HH: MM of a cell stored as "dd/mm/yyyy hh:mm format in Excel?

Question

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

How I can do it

Solution 1

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

Solution 2

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

=mod(A1,1)

Format as time.