How to fix script error(s) in computing total hours given Start and Finish Time?

[Henry.Ong]

Good day!

Last week I posted a question about getting the hours difference between the Start Time and Finish Time belonging to the same day.

The solution I got seemed to be ok except when I entered the following:

Start Time = 8:00 am

Finish Time = 8:15 am

Unbilled Hours = 0.00

The formula for computing Total Hours = (Finish Time – Start Time) – Unbilled Hours.

The correct answer should be 0.25 Hours but it is giving me 0.30 hour

The result is the same if I entered the following:

Start Time = 8:00 am

Finish Time = 8:45 am

The correct answer should be 0.75 Hour but it is giving me 0.80

On the other hand, if I enter the following:

Start Time = 8:00 am

Finish Time = 8:30 am

The result is correct which is 0.50 hours.

The solution I got consisted of a document-level script (name “Time”), as shown below:

function Time(start,finish,unpaid){

if (start!="" && finish!="") {

                var h0=Number(start.substr(0,2));

                if (start.indexOf("am")>-1 && start.substr(0,2)=="12") var h0=0;

                else if (start.indexOf("pm")>-1 && start.substr(0,2)!="12") h0+=12;

                var m0=+Number(start.substr(3,2));

                var t0=h0*60+m0;

                var h1=Number(finish.substr(0,2));

                if (finish.indexOf("am")>-1 && finish.substr(0,2)=="12") var h1=0;

                else if (finish.indexOf("pm")>-1 && finish.substr(0,2)!="12") h1+=12;

                var m1=+Number(finish.substr(3,2));

                var t1=h1*60+m1;

                var delta=(t1-t0)/60;

                if (delta>0) event.value=(delta-Number(unpaid)).toFixed(1);

                else {

                                event.value="";

                                app.alert("Finish Time should not be earlier than Start Time.",3);

                }

} else {

                event.value="";

}

}

And the Custom Calculate Script is…

Time(this.getField("F02001d").value,this.getField("F02001e").value,this.getField("F02001f").value)

Field names are:

F02001d = Start Time

F02001e = Finish Time

F02001f = Unbilled Hours

I hope someone can help me resolve this issue with the computation.

Thank you in advance.

[Bernd Alheit]

Try:

toFixed(2)

[Henry.Ong · Accepted solution]

Thanks Bernd. Script is working correctly.

[bebarth · Accepted solution]

Hi,

Correct, use "toFixed(2)".

You can't use "event.value" in the function in document-level. Use the name of the field the function comes from.

@+

[Bernd Alheit]

It is possible to use event.value in a function.

[Henry.Ong]

Thanks Bebarth. Script is working correctly.