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.

Need Help in Calculating Time: Total Time Worked *DELETED*

noaspenwin
in The Left Brain

Featured Replies

Post deleted by noaspenwin

Did you format your fields as time fields?

time_end - time_start = time_total

time_break_end_1 - time_break_start_1 = time_break_total_1

time_break_end_2 - time_break_start_2 = time_break_total_2

etc.

So your final time is:

time_total - time_break_total_1 - time_break_total_2 - etc.

Look at some examples at www.fmfiles.com/enduserbus5.html

  • 2 weeks later...
  • Newbies

The calculation above is nice when the job start & end is on the same day, but when the stop time is at 02.00h is and the start time was 18.00h the calculation doesn't funtion as it suposed to do.

( 86400 are the seconds in a day )

work time =

If ( (stopTime + 86400) - startTime > 86400 ; (stopTime - startTime) ; ((stopTime + 86400) - startTime ) - BreakTime )

Create an account or sign in to comment

https://fmforums.com/topic/24026-need-help-in-calculating-time-total-time-worked-deleted/
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.