Time conversion to General format

[kyddrivers]

I am in need of converting an existing column of data from the exported format of 3/3/2014 9:00:00 AM to 0900 in general format

Example [TABLE="width: 500"]
<tbody>[TR]
[TD]3/3/2014 9:00:00 AM[/TD]
[TD]0900[/TD]
[/TR]
[TR]
[TD]3/3/2014 6:00:00 PM[/TD]
[TD]1800
[/TD]
[/TR]
</tbody>[/TABLE]

and so on and so forth...

Thanks for the help!!!

 

[BrianMH]

Use the text formula.

=TEXT(A1,"HHMM")

 

[kyddrivers]

Nice and Easy!!

Thanks for the help!!