Expand my Community achievements bar.

Hour format issue

Avatar

Former Community Member

Hi,

I've got a format issue in a form which calculate time sheet.

In the result field, the format is 0:0, not 00:00... But, i've choose HH:MM... I can't resolve it.

Have U an idea ?

Thanks

(Here I paste the code cause I can't find how upload the pdf form)

var mins = new Array()

var minsTotal = 0;

if (formulaire1.form.id_candidat.Tableau1.r2.c2.rawValue != null){

mins = formulaire1.form.id_candidat.Tableau1.r2.c2.rawValue.split(":")

minsTotal += parseInt((parseInt(mins[0]) * 60) + parseInt(mins[1]))

}

if (formulaire1.form.id_candidat.Tableau1.r2.c3.rawValue != null){

mins = formulaire1.form.id_candidat.Tableau1.r2.c3.rawValue.split(":")

minsTotal += parseInt((parseInt(mins[0]) * 60) + parseInt(mins[1]))

}

if (formulaire1.form.id_candidat.Tableau1.r2.c4.rawValue != null){

mins = formulaire1.form.id_candidat.Tableau1.r2.c4.rawValue.split(":")

minsTotal += parseInt((parseInt(mins[0]) * 60) + parseInt(mins[1]))

}

if (formulaire1.form.id_candidat.Tableau1.r2.c5.rawValue != null){

mins = formulaire1.form.id_candidat.Tableau1.r2.c5.rawValue.split(":")

minsTotal += parseInt((parseInt(mins[0]) * 60) + parseInt(mins[1]))

}

if (formulaire1.form.id_candidat.Tableau1.r2.c6.rawValue != null){

mins = formulaire1.form.id_candidat.Tableau1.r2.c6.rawValue.split(":")

minsTotal += parseInt((parseInt(mins[0]) * 60) + parseInt(mins[1]))

}

this.rawValue = parseInt(minsTotal/60) + ":" + parseInt(minsTotal%60);

----- formulaire1.form.id_candidat.Tableau1.r3.c7::calculate: - (JavaScript, Client) ---------------

var mins = new Array()

var minsTotal = 0;

if (formulaire1.form.id_candidat.Tableau1.r3.c2.rawValue != null){

mins = formulaire1.form.id_candidat.Tableau1.r3.c2.rawValue.split(":")

minsTotal += parseInt((parseInt(mins[0]) * 60) + parseInt(mins[1]))

}

if (formulaire1.form.id_candidat.Tableau1.r3.c3.rawValue != null){

mins = formulaire1.form.id_candidat.Tableau1.r3.c3.rawValue.split(":")

minsTotal += parseInt((parseInt(mins[0]) * 60) + parseInt(mins[1]))

}

if (formulaire1.form.id_candidat.Tableau1.r3.c4.rawValue != null){

mins = formulaire1.form.id_candidat.Tableau1.r3.c4.rawValue.split(":")

minsTotal += parseInt((parseInt(mins[0]) * 60) + parseInt(mins[1]))

}

if (formulaire1.form.id_candidat.Tableau1.r3.c5.rawValue != null){

mins = formulaire1.form.id_candidat.Tableau1.r3.c5.rawValue.split(":")

minsTotal += parseInt((parseInt(mins[0]) * 60) + parseInt(mins[1]))

}

if (formulaire1.form.id_candidat.Tableau1.r3.c6.rawValue != null){

mins = formulaire1.form.id_candidat.Tableau1.r3.c6.rawValue.split(":")

minsTotal += parseInt((parseInt(mins[0]) * 60) + parseInt(mins[1]))

}

this.rawValue = parseInt(minsTotal/60) + ":" + parseInt(minsTotal%60);

----- formulaire1.form.id_candidat.Tableau1.r4.c7::calculate: - (JavaScript, Client) ---------------

var mins = new Array()

var minsTotal = 0;

if (formulaire1.form.id_candidat.Tableau1.r4.c2.rawValue != null){

mins = formulaire1.form.id_candidat.Tableau1.r4.c2.rawValue.split(":")

minsTotal += parseInt((parseInt(mins[0]) * 60) + parseInt(mins[1]))

}

if (formulaire1.form.id_candidat.Tableau1.r4.c3.rawValue != null){

mins = formulaire1.form.id_candidat.Tableau1.r4.c3.rawValue.split(":")

minsTotal += parseInt((parseInt(mins[0]) * 60) + parseInt(mins[1]))

}

if (formulaire1.form.id_candidat.Tableau1.r4.c4.rawValue != null){

mins = formulaire1.form.id_candidat.Tableau1.r4.c4.rawValue.split(":")

minsTotal += parseInt((parseInt(mins[0]) * 60) + parseInt(mins[1]))

}

if (formulaire1.form.id_candidat.Tableau1.r4.c5.rawValue != null){

mins = formulaire1.form.id_candidat.Tableau1.r4.c5.rawValue.split(":")

minsTotal += parseInt((parseInt(mins[0]) * 60) + parseInt(mins[1]))

}

if (formulaire1.form.id_candidat.Tableau1.r4.c6.rawValue != null){

mins = formulaire1.form.id_candidat.Tableau1.r4.c6.rawValue.split(":")

minsTotal += parseInt((parseInt(mins[0]) * 60) + parseInt(mins[1]))

}

this.rawValue = parseInt(minsTotal/60) + ":" + parseInt(minsTotal%60);

----- formulaire1.form.id_candidat.Tableau1.r5.c7::calculate: - (JavaScript, Client) ---------------

var mins = new Array()

var minsTotal = 0;

if (formulaire1.form.id_candidat.Tableau1.r5.c2.rawValue != null){

mins = formulaire1.form.id_candidat.Tableau1.r5.c2.rawValue.split(":")

minsTotal += parseInt((parseInt(mins[0]) * 60) + parseInt(mins[1]))

}

if (formulaire1.form.id_candidat.Tableau1.r5.c3.rawValue != null){

mins = formulaire1.form.id_candidat.Tableau1.r5.c3.rawValue.split(":")

minsTotal += parseInt((parseInt(mins[0]) * 60) + parseInt(mins[1]))

}

if (formulaire1.form.id_candidat.Tableau1.r5.c4.rawValue != null){

mins = formulaire1.form.id_candidat.Tableau1.r5.c4.rawValue.split(":")

minsTotal += parseInt((parseInt(mins[0]) * 60) + parseInt(mins[1]))

}

if (formulaire1.form.id_candidat.Tableau1.r5.c5.rawValue != null){

mins = formulaire1.form.id_candidat.Tableau1.r5.c5.rawValue.split(":")

minsTotal += parseInt((parseInt(mins[0]) * 60) + parseInt(mins[1]))

}

if (formulaire1.form.id_candidat.Tableau1.r5.c6.rawValue != null){

mins = formulaire1.form.id_candidat.Tableau1.r5.c6.rawValue.split(":")

minsTotal += parseInt((parseInt(mins[0]) * 60) + parseInt(mins[1]))

}

this.rawValue = parseInt(minsTotal/60) + ":" + parseInt(minsTotal%60);

0 Replies