I'm calculating some sums of gain over time - therefore I want to divide X by time required to generate X.The problem here is, that the SECOND function in the =(SUM(B4:B18)/SECOND(SUM(A4:A18)))*60 formula returns second portion (mod 60), not second sum (with hours*3600 and minutes*60).So how can I convert duration field into integer representing number of seconds for that duration?
Get duration as seconds google spreadsheet
google spreadsheets