Forum Discussion
Helper IIUpload data that has unknown hours
Hi
I am trying to upload a spreadsheet that has hh:mm:ss of 99:99:99 due to hours are unknown. How do I upload those hours to retain the data as unknown hours?
Thank you
Hi Marshmallow
Either keep a duplicate copy of the column as text or retain the original column in text format. Converting the column to time will cause errors for values that Power Query cannot parse, and those entries will be loaded as nulls.
4 Replies
- danextian
Super User
Hi Marshmallow
Either keep a duplicate copy of the column as text or retain the original column in text format. Converting the column to time will cause errors for values that Power Query cannot parse, and those entries will be loaded as nulls.
v-sgandrathiCommunity Support
Hi Marshmallow
Has your issue been resolved?If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.
Thank you for your understanding!
- v-sgandrathi
Hi Marshmallow ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
- v-sgandrathi
Hi Marshmallow,
We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thank you.