Hello,

I want to extract the from these cells only the hour:

9/3/2007 2:25:46 AM cell value must become 02
9/3/2007 2:25:46 PM cell value must become 14

I can use date format to show only "hh", but cell value is still
"9/3/2007 2:25:46 AM"