Ask Your Question

brynekaren's profile - activity

2014-02-07 12:42:45 +0200 received badge  Famous Question (source)
2014-02-02 18:10:13 +0200 received badge  Student (source)
2014-02-02 18:08:35 +0200 received badge  Notable Question (source)
2014-02-02 13:29:27 +0200 received badge  Popular Question (source)
2014-02-02 09:13:47 +0200 asked a question How to calculate minutes per kilometer?


In Excel you have a formula that calculates minutes per kilometer automatically and I wonder how I can do this in Calc. I am organising a run and for the result I use normally Excel but want to change to Calc.

So for a race that is 9,75km long - if a user uses 00:45:23 (o hrs, 45mins, 23sec) in Excel I normally just write Time/Distance and I get Minutes per km. Not sure how I can do this in Calc. Do I need to create a macro? I tried today with Calc 4.2 and it is the same.