View Single Post
 
Old 09-22-2019, 02:31 PM
Logit Logit is offline Windows 10 Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

What I've been able to determine.

As you indicated ... the times are being brought over from a PDF file. That format is very different from Excel's, requiring it be converted to something Excel understands / recognizes.

I tried several free online conversion sites with the data located in Col D. I also attempted a conversion with a macro in Excel. Did not have any success.

The times are currently seen by Excel as hours / minutes ... instead of minutes / seconds. No matter what FORMAT you use in Excel, without the proper conversion first from PDF to Excel .... you will most likely always receive an error.

I am unable to advise you what next step to take ... other than continue attempting to convert the original file from PDF to Excel first. Alternative is to manually enter the information.

Perhaps someone else will have an automated process.

Sorry.
Reply With Quote