Displaying Hours & Minutes records

Hi,
I have a page that collects hours and minutes in separate fields.

I know that I can restrict the numbers added to the minute field, but let’s say I have 10 entries of 10 minutes each. If I sum them up, it will give me a duration of more than 1 hour.

I need help to get the formula working. This is my current formula, but it’s not working for minutes more than 59.

image

I need help please :slightly_smiling_face:

Hi Alvin,

This should work:

image

image

The expression was created with the beta feature ‘Expression parentheses’ active, it will make your Bubble life much easier:

Update: You might have to add a rounded down to 0 in case someone records 10 hours and 301 minutes by mistake. Without it you will see something like 15 : 0.99999999996.

image

This topic was automatically closed after 70 days. New replies are no longer allowed.