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.
