I have a textfile, that I need to import to Excel, and extract specific data to a pivottable. Unfortunately I do not receive the the specification in a way, that gives me the time in a way that Works for me.
The textfile states Time as 102345 which corresponds to 10:23:45.
I thought I could convert that by using this formula:
;2)) and format this to a time format.
In my import it seems to Work fine, but when I import to a pivottable and wants to Group by the hour, I get the error that it is not possible to Group these data.
I have the time from the text file in column C and my calculated time in column U.
Any solutions on how to solve the problem, so I can get my hourly pivottable