Hi.

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.