Forum Discussion
Convert timestamp to Time in Power Query
Hi Experts I have found the following online..... 1. 74928 should read 07:49:28 2. 164054 should read 16:40:54 and so on Custom Column = Table.ReplaceValue(#"Source",each [email_sent_t...
Hi Anonymous
If you're not getting the output you want using M, I suggest just using "Split Column by Number of Characters" and then merge.
You can then merge like below:
Output will be:
You can then change the column format type to Time:
Hope this helps!
Theo 🙂
Hi Anonymous
If you're not getting the output you want using M, I suggest just using "Split Column by Number of Characters" and then merge.
You can then merge like below:
Output will be:
You can then change the column format type to Time:
Hope this helps!
Theo 🙂