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
This is what it looks like on the screen:
divide by 60… 
floor(avarage/60)
lol thank you for the math break down. Where and how do I plug in that formula?
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
1 Like
I want it to be able to say 2 minutes and 31 seconds 2:31
never mind, easy, i got it. Thank you!
2 Likes
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:
1 Like
are you average in seconds?
yes average column is seconds
edit your average column… switch from number to duration type… in the math column change formula to: average/24/60/60
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?
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?
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
1 Like
perfect, all set! thanks!!
1 Like
@Katelyn_Alberts we’ve just added a Format Duration column to help you with this:
7 Likes
great… @david i can’t find that column