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?