Javascript decimal time to HH:MM

[Guest]

Hello

Need help with script, changing decimal time field to hours and minutes . Thanks 

[try67]

What do you mean by "decimal time", exactly? Do you mean something like 1.5 should become 1:30?

[Guest]

Hi 

Yes that is what I mean . What script could I use to change from decimal to hours and minutes. Thanks

[try67]

You can use this code as the custom calculation script of the second field (adjust the name of the first one as needed):

var v = Number(this.getField("Text1").valueAsString);
var hours = Math.floor(v);
var minutes = (v-hours)*60;
var minutesString = (minutes<10) ? "0"+minutes : ""+minutes;
event.value = hours + ":" + minutesString;

[Guest]

Thank you  . This worked perfectly

[PTI268296533rrt]

Hello, It's working but creating another decimal after minutes such as I need to convert 4.62 to minutes and results is 4:36.92 I wouldn't see .92 Would you help me please ?

[try67]

Sorry, I don't follow what you mean... Do you want to display the result in a decimal value, instead of a time format (so 3.5 instead of 3:30)?

[PTI268296533rrt]

I want to display the result in a time hh:mm instead of a decimal value (so 3:30 instead of 3.5).

I have tried with your given script the result is 3:32.49 instead of 3.54. I need only 3:32 dont need extra 49 Please see the attached.

[try67]

The script I posted doesn't include seconds at all, only hours and minutes.