Can I convert seconds to minutes?

[Katelyn_Alberts]

This is it in the database:

This is what it looks like on the screen:

At least it converts it to only .00 but I’d still like to display in minutes if possible

[Uzo]

divide by 60…

floor(avarage/60)

[Katelyn_Alberts]

lol thank you for the math break down. Where and how do I plug in that formula?

[Uzo]

math column

[Katelyn_Alberts]

seems to be rounding up to only minutes and not including seconds as well?

[Uzo]

is your average in seconds?.. that was your question… to convert to minutes… take out floor from the formula, if you wanna have numbers after decimal point

[Katelyn_Alberts]

I want it to be able to say 2 minutes and 31 seconds 2:31

[Katelyn_Alberts]

Can I template it somehow so it reads 2:31 instead of 2.31?

[Katelyn_Alberts]

never mind, easy, i got it. Thank you!

[Katelyn_Alberts]

never mind again, it’s not displaying right on the screen side
i made the template:

and then plugged it in here and it came out like this:

[Uzo]

are you average in seconds?

[Katelyn_Alberts]

yes average column is seconds

[Uzo]

edit your average column… switch from number to duration type… in the math column change formula to: average/24/60/60

[Katelyn_Alberts]

yes thats what i want it to look like but it’s not converting right

this is the one we were just looking

it’s 51 second coverted to 0.86 which is right, it should say 0:51

Do i first need to remove the milliseconds?

[Uzo]

@Uzo

edit your average column… switch from number to duration type… in the math column change formula to: average/24/60/60

follow that

@Katelyn_Alberts is it working?

[Katelyn_Alberts]

Not sure if i can/should edit that column type because it comes straight from Google Analytics that way and updates daily? Should I transfer the date into another column type first?

[Uzo]

yes, you can change… unless you need that format somewhere else in your app… data will not change… only how is displayed… so no worries

[Katelyn_Alberts]

perfect, all set! thanks!!

[david]

@Katelyn_Alberts we’ve just added a Format Duration column to help you with this:

Glide • Format Duration column

[Uzo]

great… @david i can’t find that column