Forum Discussion
Solved
Transform aggregated hours as Text to Time
Is there a way to transform this Column that holds hours and minutes (stored is text in the Query) to time hours and minutes: 00:09 14:30 74:45 23:30 31:15 ertc... Problems arise with th...
You can only transfrom this text column into a "Duration" type column. Just add a custom column like below:
=#duration(0,Number.FromText(List.First(Text.Split([Time],":"))),Number.FromText(List.Last(Text.Split([Time],":"))),0)
Regards,
You can only transfrom this text column into a "Duration" type column. Just add a custom column like below:
=#duration(0,Number.FromText(List.First(Text.Split([Time],":"))),Number.FromText(List.Last(Text.Split([Time],":"))),0)
Regards,
