Forum Discussion
Solved
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....
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.
Greg_Deckler
Community Champion
Community ChampionSang23041983 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 |