How to convert seconds to mm:ss for display

timothybrennan2 · 2020-06-10T02:29:11.625Z

I’m trying to convert mile times from seconds to minutes and seconds but I’m struggling. For example, if an individual’s mile time is 263.74 seconds, but I cant figure out how can I convert it so it shows 4:23.74 on the front end.

I’ve tried dividing the seconds by 60 and then taking the floor for the first minutes factor (263.74/60 = 4.395 → floor = 4). And then I’ve tried subtracting the total seconds by the floor value * 60 (263.74-240 = 23.74) but this does not work.

This is the goal:

conversionerrorpic691×245 10.7 KB

This is what I have. Not sure why this is an error/complicated:

image920×178 10.7 KB

Any help would be greatly appreciated!

Bubbleboy · 2020-06-10T05:42:51.099Z

i would suggest using the toolbox expression and moment.js with moment.duration(YOURVALUE, “seconds”).format(“hh:mm:ss”);

mikeloc · 2020-06-10T11:40:39.399Z

Hi there, @timothybrennan2… I’m sure Bubbleboy’s solution is a better way to go, but why not just continue down the path you are on by calculating the leftover seconds in a field and then putting the minutes and leftover seconds together in a new field?

time1

time2755×264 12.9 KB

Too hacky?

Best…
Mike

timothybrennan2 · 2020-06-10T13:39:10.594Z

Hey Mike! This is actually exactly what I was trying to do initially. I tried to use formulas to take mile time in seconds to minutes, seconds and total seconds to get to mm:ss.ms

Can you take a look at this and see what I missed? Any help would be very very much appreciated.

Bubble

Bubble Editor - Miletimeconversion

Build stuff without code and launch a startup without a tech-cofounder! Bubble is a visual programing language. Instead of typing code, use a visual editor to build applications.

timothybrennan2 · 2020-06-10T13:43:46.935Z

Thank you so much! I think this would get me exactly where I want to get to in the end. I’ve never used the toolbox expression or moment.js before. Are there any resources you would suggest to learn how to use this tools well? Again any help is very much appreciated!

mikeloc · 2020-06-10T13:56:10.776Z

Check it now, @timothybrennan2… do you see the desired result (it looks good to me)? Some of your input fields were set to text when they needed to be integer or decimal, and you had formulas in the Placeholder fields when they need to be in the Initial content fields.

Best…
Mike

sudsy · 2020-06-10T14:37:18.566Z

timothybrennan2:

I’m trying to convert mile times from seconds to minutes and seconds

You just need the modulo operator…

convert-seconds-example1287×1014 33.7 KB

Here’s an example (edit mode link in upper right).

timothybrennan2 · 2020-06-13T02:44:21.088Z

Yes that is exactly what I was looking for. Thank you so much Mike! Learned a ton from your help and example

system · 2020-08-19T02:29:11.603Z

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