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.

Time variable

FM Bash!
in Calculation Engine (Define Fields)

Featured Replies

I am helping a friend and got stuck. please help.

This is what I have for a total break time.

I need to have 15 minutes (or .25 of an hour) to be the starting time. So, the employee is allowed 15 minutes but gets docked after this amount. I am looking for the total over 15 minutes.

Round(Hour( End Break 1 - Start Break 1 ) + Minute( End Break 1 - Start Break 1 ) / 60 - Lunch fake,2)+If(End Break 1 <= Start Break 1,24,0)

Thank you, Don

Time is stored in seconds. 900 is the number of seconds in a 15 minute increment. So, all you have to do is subtract the two break time fields and subtract 900 seconds to be left with the number of hours, minutes and/or seconds beyond their allotted break time.

(End Break 1 - Start Break 1) - 900

Make sure the result of this calculation is time.

I'm not sure I understand the "Lunch fake" field but hopefully I have provided enough information to complete your formula.

  • Author

I have added -.25 to the script and this worked for displaying a negative number but I need to begin adding time after 15 minutes, or .25 has past.

What do I need to change in this script to make this work?

Right now this script results with a negative number until time reaches 15 minutes. I need it to be 0 (zero) until time passes 15 minute.

Round(Hour( End Break 1 - Start Break 1 ) + Minute( End Break 1 - Start Break 1 ) / 60 - Lunch fake,2)+If(End Break 1 <= Start Break 1,24,0) - .25

Create an account or sign in to comment

https://fmforums.com/topic/43393-time-variable/
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.