Best way to store minutes/seconds?

Need help Database
1

Struggling with this…

In my app people will be entering benchmarks for how long it took them to do something. The format should be HH:MM:SS.

What is the best way to capture and store this data? I tried Bubble’s date/time picker, and airdatetimepicker but can’t seem to figure it out… Would I be best having one input for the entire value, seperate inputs for hours, minutes, seconds.

Ideally I’d like to do calculations between times etc. eventually.

Thanks :slight_smile:

2

You can save the start date and end date in two fields. Then you can calculate the difference between those two dates, and read the result with a plugin like this one [NEW PLUGIN]: number to text HH:MM:SS

if you search the forum there are plenty of topics for the same question

3

Thanks Sarah, I had a search but couldn’t quite find anything.

There won’t be a start and end, it’ll just be time taken to do X.

Also, I don’t want to capture date which is maybe where my confusion is.

4

what I meant is that you will need to save dates, but temporary.

You start a task A, save in this row the start time (current date time), and when stopped, save in another field named duration (number type) current date time - Task A’s start date (which saves also the time) fomatted as minutes or seconds (according to the plugin you ll use to display the time.

When re-start the task, save current date time as start date and then save in duration field “current date time - start date formatted as min/sec + this task duration”

got it ?

5

Don’t quite got it… :smiley:

Following is my UI, which may help you provide advice:

Screenshot 2023-10-12 at 5.54.02 pm
Screenshot 2023-10-12 at 5.54.02 pm1260×1408 75.2 KB

I might actually look to remove hh mm ss for this particular exercise, given it would never take over 60 seconds to do a 10m sprint. However, for 1200m test, there minutes would be required

6

What I’m thinking I will do is:

  • have seperate inputs (numbers) for Hours, Minutes, Seconds and Milliseconds
  • in my Data Type have a field for each input (for quick display),
  • and then a total ms field which I’ll use a formula to work out on saves/updates

(5 fields total)

The total ms field is what I’ll use for calculations on the difference between times.

Is this ridiculous, and is there an easier/out of the box/plugin/more straightforward way???

8

Hmmm thanks for the suggestion but not sure this will be overly user-friendly with our staff inputting data…

I’m at the point of having the following…

Screenshot 2023-10-12 at 9.43.10 pm
Screenshot 2023-10-12 at 9.43.10 pm1274×1144 39 KB

However, I’d like to limit:

  • Minutes to 60 (60 minutes in an hour)
  • Seconds to 60 (60 seconds in a minute)
  • Milliseconds to 1000 (1000 milliseconds in a secon)

I ended up setting the input type to ‘Text (Numbers only)’ so that I could control the max length of characters (2, 2, 4), however, there’s no way for me to control the highest number.

When I swap to a Integer type, I can set max number which triggers error validation, but the user can still type above 60. There’s also no way to limit amount of chracters with an integer.

Sigh… This seems like straightforward functionality :confused: