Making the Time in to same format

Hi,

Thank You

But I am getting errors as follows:

so I try to change the transaction time from following code

if Text.Length([Transaction Time])>6 then [Transaction Time]

else

Text.Middle(Text.From([Transaction Time]),0,2) & ":" &

Text.Middle(Text.From([Transaction Time]),2,2) &":" &

Text.Middle(Text.From([Transaction Time]),4,2)

but It didn`t give the required output.

Hi Dora,

It seems like that there exists some special formats. Like7597, it should be 075907. Right?

For this scenario, my solution will not work. And if there are not many errors. I would suggest you to change the initial Time to the required format manually at Excel file side. I think it will be the easiest method.

Thanks,
Xi Jin.