Date and time to time

[Jranchhod]

Hi All

I receive data in a SQL format in Excel daily. One of the rows have a Date and time stamp to it
How do i change this to just a time format.

I have tried format cells, time however, not working

3/25/2013 7:14 Thank you <tbody> </tbody><colgroup><col></colgroup>

<tbody>
</tbody><colgroup><col></colgroup>

 

[JB_Scotland]

format the cell as time hh:mm

 

[Useful]

Hi! try "customize regional options" according this format (date seperator as "/")

 

[Sixthsense]

Seems to be having a line break inside the date and time is it so?

 

[Useful]

That is normal case. (use now() function and convert it to values u'll see)