minute:seconds number format

2.42K viewsGeneral Discussion
0
0 Comments

I want to format the number of an item as minutes and seconds like so:

1:17

which would be one minute seventeen seconds. I’d like to apply a growth function to this item so the results are consistent with that format. Is this possible using the “custom” format?

thanks.

2 Answers

0
ltaber72 0 Comments

Perfect. The sample model you attached explains everything.

0
pete110 0 Comments

you can use the custom format of m:ss to format times like you describe. I’ve attached a model which uses the time() function to increment a starting time by 20 seconds in each slice.

Does that get at your question?

Cheers,

pete

Attachments

time.model
1049 Questions total questions asked
83 Solved total solved questions
2611 Answers total answer posted
12746 Total users total community members