Upload data that has unknown hours

[Marshmallow]

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

[v-sgandrathi]

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.

[danextian · Accepted solution]

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.