Skip 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 calculation

lonesomejubilee
in Calculation Engine (Define Fields)

Featured Replies

Hi

I'm trying to write a time card db, and I don't like the template, so I'm going to make my own. I need it to run 24 h ours so how would I write a calculation so if someone clocks in at 23:00 and out at 7:00 it will show as 8 hours instead of -16 hours?

Thanks...

Vandy

Use TimeStamp instead of time. Use time for the result of you calculation. Or do you own calculations, timestamp is number of seconds.

  • Author

Will it still calculate past the date line?

  • Author

Thanks, one last question.... the timestamp calculated correctly, but I don't like the way it looks... having both the date and time... is there anyway to truncate it to just the time?

GetAsTime ( timestamp )

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

Account

Navigation

Search

Search

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.