Forum Discussion
Time stamp
Time
12:15
08:30
16:00
120:40:00
200:30:00
This is my input , After loaded into Power query editor
Time
12:15:00
08:30:00
16:00:00
00:40:00
08:30:00
The output is like above value.
Can anyone please help, how I will get the same value after loaded into power query editor.
Hi Sang23041983
Try delete the step : Changed Type in power query
This is the result
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Sang23041983 Looks like you are changing the data type. Perhaps import it as a text column instead of converting it?
Imported as TEXT data type. But the result is
31-12-1899 12:15:00 31-12-1899 08:30:00 31-12-1899 16:00:00 05/01/1900 00:40:00 08/01/1900 08:30:00
Hi Sang23041983
Try delete the step : Changed Type in power query
This is the result
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
