Created attachment 21952 [details]
Fixes of the date formated data with am/pm

For any date cell with am/pm in the format isn't regarded as date formated data. For example: isADateFormat return false with the cell of '4/2/2007  12:00:00 AM'.
The simple fixes attached below:
Index: src/java/org/apache/poi/hssf/usermodel/HSSFDateUtil.java
===================================================================
--- src/java/org/apache/poi/hssf/usermodel/HSSFDateUtil.java	(revision 655573)
+++ src/java/org/apache/poi/hssf/usermodel/HSSFDateUtil.java	(working copy)
@@ -226,7 +226,7 @@
     	
     	// Otherwise, check it's only made up, in any case, of:
     	//  y m d h s - / , . :
-    	if(fs.matches("^[yYmMdDhHsS\\-/,. :]+$")) {
+    	if(fs.matches("^[yYmMdDhHsSAP\\-/,. :]+$")) {
     		return true;
     	}