Forum Discussion
Time Duration to Date Conversion
Hi ALL, New Bee here. I have a client request today to convert a Time Duration column to Date (As shown in the table). Can you experts please help me to achieve the exact date format with the code....
amitchandak
Super User
Super UserAnonymous , You can split it on power Query using split by delimiters. Then you can remove the text.
Then you add it date
date(2022,01,01) + [week]+7 + [Day] + Time([Hour], [Minute], 0)
Hi Amit,
Thanks for the reply. I did get your suggestion.
As my input is in Duration , how can we convert the same into a date column. Thanks.