Input box value conversion

[sridhar_sigired]

Hi,

I have a input box where user enters the value (seconds), if user enters 180, then it has to convert as 03:00 (as minutes) in input box, i need to use this variable in my expression calculation.

Tried with different option like positive integer, predefined values etc but did not work.

Can any one help me out?

[jonathandienst]

Divide by 60 to convert to decimal minutes or divide by 86400 (24x60x60) to convert to a QV time/interval value which you can then format withe the Interval() format function:

     =Interval(yourFieldinseconds / 86400, 'hh:mm')

[sridhar_sigired]

Thanks Janathan, do i need to keep this expression at custom field in input constraint of Input box?

Actually here i am showing input box and user will enter some value which is in seconds, however it should be converted into mm:ss format while displaying it.

[jonathandienst]

Use the expression where you are displaying it.