Convert Time into number for Payroll calculations in PowerQuery [Office 2013]

[kachaloo]

Hey guys.
I am doing my first Power Query project using and have successfully transformed data are I wanted that I could not do in PowerPivot. However I need to convert the hours worked by each employees into Number so that I can take that number and use it in the payroll software to calculate wages.

I am using the formula =INT(A1)*24+HOUR(A1)+ROUND(MINUTE(A1)/60,2) to convert it numbers however I am struggling to understand how can I use it in PowerQuery by adding a new column as.

Also while on topic I am also looking for way to clear data by second last of the month and adding last month final week from Saturday till end of the month. i.e whats left over from previuos month after 2nd last friday of the month. and tag it say MAR20 from 22/02/2020 to 20/03/2020. At the moment I have it manually entered as Feb20 and March 20..

Thanks

 

[sandy666]

Table.AddColumn(#"Previous step", "Hour", each Time.Hour([aa]), Int64.Type)
Table.AddColumn(#"Previous step", "Minute", each Time.Minute([aa]), Int64.Type)
Table.TransformColumns(#"Previous step", {{"Minute", each _ / 60, type number}})
Table.AddColumn(#"Previous step", "Addition", each [Hour] + [Minute], type number)

 

[sandy666]

or just add custom [Payable Hours] column: Time.Hour([Hours Worked])+Time.Minute([Hours Worked])/60

 

[kachaloo]

wow thanks for a quick reply.
Yes it perfect. Thank you.
Time.Hour([Hours Worked])+Time.Minute([Hours Worked])/60

 

[sandy666]

You are welcome
Thanks for the feedback