Forum Discussion
Duration errors
I should've explained more clearly, I'm sorry. It's not text data, but a date/time information formated in excel. More realistic view of the data is shown on the picture - in the Power Query View.
Now that I think about it, the first step should be to express the difference between the date in the second column and the date 31.12.1899 00:00:00. That will give a real duration value that I will then be able to work with.
Community ChampionI'm a bit confused about how this data (example 27h 14m 23s) ever converted to Duration type without a more complex parsing function. It's going to throw an error with any of the basic conversion-to-duration functions.
Is that the error you are getting?
I should've explained more clearly, I'm sorry. It's not text data, but a date/time information formated in excel. More realistic view of the data is shown on the picture - in the Power Query View.
Now that I think about it, the first step should be to express the difference between the date in the second column and the date 31.12.1899 00:00:00. That will give a real duration value that I will then be able to work with.