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

Time Calculation - Total Min to Hrs and Min?

theyetti
in Calculation Engine (Define Fields)

Featured Replies

Hi All, hopefully this one isn't going to be as hard as I think it is.

I want to record my working time for the day, I start at 8:00am and finish at 4:30pm with 30mins for lunch. I've worked out daily total in minutes (480 usually) but I would like to display this as hour and minutes. For instance if I start at 8:10am my total for the day would be 470 minute and I would like to display as 7:50. This last part I can't work out - Is it possible?

Thanks Pedro :(-)

Calculation = 470 * 60 and make result a time field (use your minutes field in place of the 470). Then manipulate the display: right-click field, select Time Format.

However, I would bet it can be simplified if I knew the fields in question. Can you post your test file?

Edited by Guest

  • Author

Hi LaRetta, thanks, it works prefectly :(-)

I've already reduced the fields and calculations to the minimum needed but had trouble with displaying the data as I wanted it.

I kept on thinking I had to divide to get the correct result.

Kind Regards,

Pedro :-)

Edited by Guest

Create an account or sign in to comment

https://fmforums.com/topic/45377-time-calculation-total-min-to-hrs-and-min/
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.