I am currently working on analysis of a dataset from excel that includes hour data. However, when I load the dataset into R the column which is the hour data shows up as only NAs. It also says the column is a lgl object. I tried reformatting the hour data in excel to remove the 1:00 structure to just 1, because I thought maybe that was the problem, but the same thing is happening. The data set is way too big to manually create another.
Any help would be much appreciated!!