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.
Juggernaut

Finding the diffrence in time

krmullins
in Calculation Engine (Define Fields)

Featured Replies

I need to do a couple of things related to time but my math skills are not getting the job done.

Any help would be appreciated.

I have a perfect time (pt) and an actual time (at) I need to find the difference between those two in non negative numbers, and then have text that will tell me if the difference is late or early.

example 1

pt = 13:14:25

at = 13:14:26

desired result

Field 1 = at - pt = 1

Field 2 = at - pt = late

example 2

pt = 13:14:25

at = 13:13:24

desired result

field 1 = at - pt = 61

field 2 = at - pt = early

example 3

input

pt = 13:14:25

at = 13:14:25

desired result

field 1 = at - pt = 0

field 2 = at - pt = zero

Field 1 represents the difference between pt & at in seconds and needs to be positive so I can do a sum to get the total difference in time over multiple checkpoints.

Thanks Kevin

timing.zip

Field 1 (result is Number ) =

Abs ( pt - at )

Field 2 (result is Text ) =

Choose ( 1 + Sign ( pt - at ) ; "Late" ; "Zero" ; "Early")

  • Author

Thanks comment that is perfect.

I figured there had to be something that would give an absolute number, I just couldn't think of how I could state it.

The sign I never would have got.

Create an account or sign in to comment

https://fmforums.com/topic/46413-finding-the-diffrence-in-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.