Calculate Running Pace

[KineticConnect]

hello,

I want to create ability to calculate average pace (minutes per km), where the user inputs duration taken (hh:mm:ss) and disatnce (kilometers). 

In sheets the calculation is straightforward, =time/distance. When I use this in Appsheet i get the following error

Column 'VirtPAce (min/km)' in Table 'Runningcalclutlors_Schema' of Column Type 'Decimal' has an invalid expression in the Formula field.'=[Time]/[Pace (min/km)]'. Date arithmetic expression ([Time]/[Pace (min/km)]) has an invalid operator

Any suggestions how I can tidy this up to output the correct values?

[diogolupcosta]

The result of your expression is not valid in Appsheet. You must convert the duration column into minutes to get a result (min/min).

Use the formula TOTALMINUTES() in the durantion column to get it right 

[KineticConnect]

Thank you for the reply. Complete Noob here.

What do i put in the brackets? ()

[KineticConnect]

Understand what you arw re saying, but unable to figure out how to do it!

[diogolupcosta]

TOTALMINUTES([Time]) / [Pace (min/km)]

[KineticConnect]

Should I do this in the google sheet, or in Appsheet?

[diogolupcosta]

on a Virtual column in Appsheet:

put your duration column inside the totalminutes([DURATION COLUMN]) / [KM COLUMN]

it should work

[KineticConnect]

this seems to do it

TEXT(FLOOR((TOTALMinutes([Time]))/[Distance(Km)]))&":"&TEXT(ROUND(DECIMAL(RIGHT(TEXT((TOTALMinutes([Time]))/[Distance(Km)]),3))*60))

[Steve]

TOTALMINUTES() - AppSheet Help

[KineticConnect]

TEXT(FLOOR((TOTALMinutes([Time]))/[Distance(Km)]))&":"&TEXT(ROUND(DECIMAL(RIGHT(TEXT((TOTALMinutes([Time]))/[Distance(Km)]),3))*60))