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.

Date and Time

trevors
in The Left Brain

Featured Replies

I have 4 fields ...

Date Start

Time Start

Date Finish

Time Finish

I want to calculate the difference in Hours and minutes between them (this is either very simple and I missed it, or very complex ... for me anyway).

The dates: I have a Mini Calandar for user to update.

The Time field: Pop-up list in 1/2 hour blocks (24 hours).

Or is this the wrong way to even start?

This formula:

( EndDate - StartDate ) * 86400 + EndTime - StartTime

will return the difference in seconds. If you set the result type to Time, it will display as h::mm::ss (or whatever time format you select for the field in Layout mode). The method you use to input data into the fields does not matter to the calculation.

  • Author

Thank you very much ... this one is busted thanks to you. It was not as hard as I thought, I was kinda on the right track, you just saved me many hours of work before I worked it out - Like 2-3 days:-)

Again Thanks

Trevors

Create an account or sign in to comment

https://fmforums.com/topic/47131-date-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.