decimal to mm:ss

Avatar

Avatar
Validate 1
Level 1
BendMaster150
Level 1

Like

1 like

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
BendMaster150
Level 1

Like

1 like

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
BendMaster150
Level 1

16-05-2019

I have done a whole bunch of searches. Seen lots of posts but doesn't help what i am trying to do. I have many drop down fields that will equal different number values(Seconds) At the end of the form I have a field where it uses formcalc to sum all the fields. I then want to convert that totaled decimal number to mm:ss format.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Coach
MVP
radzmar
MVP

Likes

397 likes

Total Posts

2,687 posts

Correct reply

492 solutions
Top badges earned
Coach
Ignite 3
Ignite 1
Validate 1
Give Back 50
View profile

Avatar
Coach
MVP
radzmar
MVP

Likes

397 likes

Total Posts

2,687 posts

Correct reply

492 solutions
Top badges earned
Coach
Ignite 3
Ignite 1
Validate 1
Give Back 50
View profile
radzmar
MVP

16-05-2019

To display the result you should use a text field instead.

Answers (3)

Answers (3)

Avatar

Avatar
Validate 1
Level 1
BendMaster150
Level 1

Like

1 like

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
BendMaster150
Level 1

Like

1 like

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
BendMaster150
Level 1

16-05-2019

That worked!

Do you have one if I decided to display HH:MM:SS?

Avatar

Avatar
Validate 1
Level 1
BendMaster150
Level 1

Like

1 like

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
BendMaster150
Level 1

Like

1 like

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
BendMaster150
Level 1

16-05-2019

Thanks!

I tried that however I'm not sure I'm applying it correctly. All the fields i have are numeric fields not time fields. Do I have to force a display pattern to my totaling numeric field?

Avatar

Avatar
Coach
MVP
radzmar
MVP

Likes

397 likes

Total Posts

2,687 posts

Correct reply

492 solutions
Top badges earned
Coach
Ignite 3
Ignite 1
Validate 1
Give Back 50
View profile

Avatar
Coach
MVP
radzmar
MVP

Likes

397 likes

Total Posts

2,687 posts

Correct reply

492 solutions
Top badges earned
Coach
Ignite 3
Ignite 1
Validate 1
Give Back 50
View profile
radzmar
MVP

16-05-2019

Hi,

that's quite simple:

var iSeconds = SummaryField ;replace with the name of your summary field

var iMin = Floor(iSeconds / 60)

var iSec = Mod(iSeconds, 60)

$ = Concat(Format("99",iMin), ":", Format("99",iSec)) ; display results in format mm:ss