Power Query covert secs to hr-min format or mins

[tigerzen]

Downloaded data comes with several columns in seconds format eg 8000 secs, can it be cleaned up quickly via Power Query so that the columns containing secs reads 2 hr 13 m or simply 133 mins. I have been tackling this by creating a custom formula for each column and then dividing by 60 but this gets a bit tedious when there are 10 or more columns in seconds.

 

[tigerzen]

Just realised that this should have been posted in another section, apologies.

 

[James006]

Hi,
You can test

let
    Source = #table(type table[Seconds = Int64.Type],{{5276}, {12675}, {76538}}),
    #"Added Custom" = Table.AddColumn(Source, "Time", each #time(0,0,0) + #duration(0,0,0,[Seconds]), type time)
in
    #"Added Custom"

 

[tigerzen]

Thanks James, that's really close. I will need to perform calculations on these values so can your query be modified so that it converts the field/columns to mins, eg the first entry which reads 5276 is simply changed to 87.9 (mins) or 88. Once it has been converted the original column with seconds is no longer required. I had thought that possibly all the columns containing seconds data could be converted directly into mins but maybe the custom columns are required and once set up the original columns with seconds could be removed.