# I need script to convert seconds to minutes and seconds example 75 seconds. need to display as 1.15 **URL:** \ **Category:** Ignition\ **Created:** [September 21, 2017, 7:26pm UTC](https://forum.inductiveautomation.com/t/i-need-script-to-convert-seconds-to-minutes-and-seconds-example-75-seconds-need-to-display-as-1-15/15431 "2017-09-21T19:26:45Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![jpuszkar](https://avatars.discourse-cdn.com/v4/letter/j/a88e57/32.png) [@jpuszkar](https://forum.inductiveautomation.com/u/jpuszkar)\ **Post date:** [September 21, 2017, 7:26pm UTC](https://forum.inductiveautomation.com/t/i-need-script-to-convert-seconds-to-minutes-and-seconds-example-75-seconds-need-to-display-as-1-15/15431/1 "2017-09-21T19:26:45Z")
I need script to convert seconds to minutes and seconds example 75 seconds. need to display as 1.15 for use in an led display. ---
**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\ **Post date:** [September 21, 2017, 8:16pm UTC](https://forum.inductiveautomation.com/t/i-need-script-to-convert-seconds-to-minutes-and-seconds-example-75-seconds-need-to-display-as-1-15/15431/2 "2017-09-21T20:16:23Z")
Both assume your input is in `Root Container.Numeric Text Field` Expression that you can bind to the LED display: `floor({Root Container.Numeric Text Field.intValue} / 60) + ({Root Container.Numeric Text Field.intValue} % 60 / 100)` Script (you’ll do something with output besides printing it…): ````auto output = (input / 60) + float(input % 60) / 100 print output``` ```` ---
**Author:** ![jpuszkar](https://avatars.discourse-cdn.com/v4/letter/j/a88e57/32.png) [@jpuszkar](https://forum.inductiveautomation.com/u/jpuszkar)\ **Post date:** [September 22, 2017, 3:07pm UTC](https://forum.inductiveautomation.com/t/i-need-script-to-convert-seconds-to-minutes-and-seconds-example-75-seconds-need-to-display-as-1-15/15431/3 "2017-09-22T15:07:54Z")
thank you very much Kathy! Now I am fighting with how to make my led display show : instead of . I am new to ignition and am coming up to speed. Once again thanks for your input! Joe ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [September 22, 2017, 4:52pm UTC](https://forum.inductiveautomation.com/t/i-need-script-to-convert-seconds-to-minutes-and-seconds-example-75-seconds-need-to-display-as-1-15/15431/4 "2017-09-22T16:52:58Z")
This is a bit more involved; you’ll also need to set the LED Display to ‘Alphanumeric’ mode, and then add this to the Text property: ```auto concat( toInt(floor({Root Container.Numeric Text Field.intValue} / 60)), ":", numberFormat(({Root Container.Numeric Text Field.intValue} % 60), "00") ) ``` ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [September 22, 2017, 4:57pm UTC](https://forum.inductiveautomation.com/t/i-need-script-to-convert-seconds-to-minutes-and-seconds-example-75-seconds-need-to-display-as-1-15/15431/5 "2017-09-22T16:57:03Z")
> [@paul-griffith](#): > > ....set the LED Display to 'Alphanumeric' mode, and then add this to the Text property: I find stringFormat() a bit more handy in such situations: ```auto stringFormat("%d:%02d", floor({Root Container.Numeric Text Field.intValue} / 60), {Root Container.Numeric Text Field.intValue} % 60) ``` ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [September 22, 2017, 4:58pm UTC](https://forum.inductiveautomation.com/t/i-need-script-to-convert-seconds-to-minutes-and-seconds-example-75-seconds-need-to-display-as-1-15/15431/6 "2017-09-22T16:58:30Z")
I honestly forgot about `stringFormat` entirely. Yeah, that’s definitely better. ---
**Author:** ![jpuszkar](https://avatars.discourse-cdn.com/v4/letter/j/a88e57/32.png) [@jpuszkar](https://forum.inductiveautomation.com/u/jpuszkar)\ **Post date:** [September 26, 2017, 3:52pm UTC](https://forum.inductiveautomation.com/t/i-need-script-to-convert-seconds-to-minutes-and-seconds-example-75-seconds-need-to-display-as-1-15/15431/7 "2017-09-26T15:52:39Z")
thank you Paul and Phil for the assistance. Works perfectly. Joe ---
**Author:** ![vec](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/vec/32/30636_2.png) [@vec](https://forum.inductiveautomation.com/u/vec)\ **Post date:** [September 27, 2017, 3:36pm UTC](https://forum.inductiveautomation.com/t/i-need-script-to-convert-seconds-to-minutes-and-seconds-example-75-seconds-need-to-display-as-1-15/15431/8 "2017-09-27T15:36:54Z")
Tried the expression but got an error: Exception: Error executing expression binding on EDIT.Root Container.LED Display.text caused by IllegalFormatConversionException: d != java.lang.Double modified the above expression to either of the 2 expressions below (to allow for the double returned by floor()) stringFormat("%d:%02d", toInt(floor({Root Container.Numeric Text Field.intValue} / 60)), {Root Container.Numeric Text Field.intValue} % 60) or stringFormat("%01.0f:%02d", floor({Root Container.Numeric Text Field.intValue} / 60), {Root Container.Numeric Text Field.intValue} % 60)