Calculate Running Pace

AppSheet AppSheet Q&A
,
1

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?

2

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

2 Likes
3

Thank you for the reply. Complete Noob here.

What do i put in the brackets? ()

4

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

5

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

1 Like
6

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

7

on a Virtual column in Appsheet:

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

it should work

1 Like
8

TOTALMINUTES() - AppSheet Help

1 Like
9

this seems to do it

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

1 Like
10

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

1 Like