@jc3992 wrote:
Thank you very much!
I've tested the link, and found it worked for me just then.
SHAREPOINT typically has a number of security features that limit who has access. So likely no one outside of your organization has access.
The issue is most likely that your "time" does not have an hour component. The TIME format expects HH:MM:SS. If this is supposed to be minutes and seconds then you will need to read the value as text and parse out the minutes, seconds and fractions of a second and use the HMS function to create a time.
Open a code box with the forum's {I} and paste text:
1994,Claudia Pechstein,GER,7:14.37
1998,Claudia Pechstein,GER,6:59.61,WR
2002,Claudia Pechstein,GER,6:46.91,WR
2006,Clara Hughes,CAN,6:59.07
2010,Martina Sablikova,CZE,6:50.92
The problem is attachments get handled by programs some of us can't control, usually a spreadsheet and once opened in a spreadsheet there is not guarantee the result looks anything like the original CSV text because the spreadsheets make assumptions and convert some values, remove or add quotes and sometimes change text to dates.
... View more