Query upload error

[crak1000]

Hello all,

I need you support to fix an error when I import data from an excel file. I have a couple of columns and in one of them I have the time when each action happens. This time is written in minutes on the original file as the follow examples: 00:00 (Minutes : Seconds) and this happens as the follw 90 minutes : 55 Seconds and so on.

when I try to updoad this into Power Query it return "error" to values bigger than 23:59. I try to assign the type of data to text but it keeps returns the same error (for example 24 minutes : 05 Seconds).

Do you know how can I sove this issue to avoid to return erro?

Thank you in advance

[v-chuncz-msft · Accepted solution]

@crak1000,

You may check steps in The Advanced Editor.