Help Distance/Time/speed

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Help Distance/Time/speed

Viewing 1 reply thread
  • Author
    Posts
  • December 18, 2022 at 5:54 AM #48496

    Hans Fontius
    Participant

    Hello,
    I’m trying to make a calculation field, where i can calculate the speed in Kilometers/hour. I’ve got the fields distance (as numbers field) and a time field formatted HH:mm.

    The speed field (km/h) ist speed/time*60.

    Is it possible to do this? How must the fields be formatted? I’ve tried some hours to do this, but without success.

    Is there somebody to help me??

    Hans

    December 19, 2022 at 2:41 AM #48497

    Brendan
    Keymaster

    Hi Hans,

    For your Time field, you’ll want to use a Number field and set the Number Format to HH:mm instead of an actual Time field. Time fields store as points in time, not as a duration value. So you need a Number field for that.

    I think once you change that you’ll be good to go with your formula.

    Thanks,

    Brendan

  • Author
    Posts
Viewing 1 reply thread

You must be logged in to reply to this topic.