Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Calculation combining number and time

KateJ
in Calculation Engine (Define Fields)

Featured Replies

I'm new! Thanks for any help anyone can provide on my problem (hopefully not everyone is at DevCon!!)

I have a calculation that involves both a number and a period of time. It's more or less this:

Miles (number field) / miles per hour (number field) + time (time field)

I need the result to be in time format.

For example:

2500 miles / 500 miles per hour + 00:15 (15 minutes) = 5:15:00

I've been fooling around with TextToTime, etc. and not getting any where.

Again, any help would be appreciated.

Time( Miles / MPH, Minute(time), 0 )

if your time may have hours,

Time( (Miles / MPH) + Hour(time), Minute(time), 0 )

  • Author

Phew!

Thanks, Queue.

Create an account or sign in to comment

https://fmforums.com/topic/25945-calculation-combining-number-and-time/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.