Can I convert seconds into mm:ss?

Carrie Holtz ✭✭

12/17/20 in Formulas and Functions

I am trying to convert my seconds into min/sec and can't seem to get any formula to work. Any help would be so great, thanks!

0 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Best Answers

• 

  MCorbin Overachievers Alumni

  12/17/20 Answer ✓

  Oops - here it is with your column name:

  =INT([Column15]@row / 60) + ":" + ([Column15]@row - (INT([Column15]@row / 60) * 60))

  1 · Share on FacebookShare on Twitter
• 

  Carrie Holtz ✭✭

  12/17/20 Answer ✓

  Thank you so much! This worked perfectly!

  0 · Share on FacebookShare on Twitter

Answers

• 

  MCorbin Overachievers Alumni

  12/17/20

  Try this:

  =INT(Seconds@row / 60) + ":" + (Seconds@row - (INT(Seconds@row / 60) * 60))

  0 · Share on FacebookShare on Twitter
• 

  MCorbin Overachievers Alumni

  12/17/20 Answer ✓

  Oops - here it is with your column name:

  =INT([Column15]@row / 60) + ":" + ([Column15]@row - (INT([Column15]@row / 60) * 60))

  1 · Share on FacebookShare on Twitter
• 

  Carrie Holtz ✭✭

  12/17/20 Answer ✓

  Thank you so much! This worked perfectly!

  0 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list