Time is read as months in pivot table

Occasional Visitor
In a sheet I have seperated a single column of date(yyyy-mm-dd) and time(24 hrs format) integrated to seperate column but yet when I create a pivot table time column is read as jan, feb, mar,.... , I have checked data type it shows correct format can any one please help me out .
Thanks for reading completely.
1 Reply


Could you attach a small sample workbook demonstrating the problem?