Skip to main content
rakeshk21205956
Inspiring
September 16, 2020
Answered

Adobe Acrobat Forms : Add a specific number at specific interval

  • September 16, 2020
  • 1 reply
  • 1382 views

I am trying to add a particular number at regular intervals

I have difference between 2 dates  in hours   

 

so  for first 24 hours  result 1  ,

even more than a minute to 24 hours >> result 1+.5 = 1.5 ,

then again even more than a minute  to next 8 hours  >> result 1.5 + .5 = 2

then again even more than a minute to next 16 hours  >> result 2 + .5 = 2.5

then again even more than a minute to next 8 hours >> result 2.5 + .5 = 3

then again even more than a minute to next 16 hours >. result  3 + .5 = 3.5   and so on.

 

In short .5 to be added after 24 hours for at every more than 8 hours & 16 hours 

 

I am using the below script  but not able to achieve the above :

 

var miles = this.getField("minutes").value; //difference between days in minutes

var hrs = Math.floor(miles/(60*24));  //capturing the hours part
var min = miles%60 //capturing the remainder minutes

 

if(hrs == "0" && min > 0){event.value =1}
else if (hrs >0 && min >0) {event.value = hrs + ".5"}
else if (hrs > 0 && min == "0"){event.value = hrs}

 

 

This topic has been closed for replies.
Correct answer rakeshk21205956

Either share the file or be more specific about what "not working" means, exactly...


Found the correct script after doing lot of permutation and combination.

Below is the script:

 

var miles = this.getField("Diff_Minutes").value; //Difference between 2 dates in Minutes
var nDays = Math.floor(miles/(60*24));  //Capturing the full Days
var rHours = Math.floor(miles/60) - (nDays*24); //Capturing the full hours remaining after full Days
var rMinutes = miles%60; //Capturing remaining minutes after capturing full days & hours

event.value = 0;

if(nDays <= 0 && (rMinutes > 0 || rHours > 0) ){event.value = 1};
if(nDays == "1" && rMinutes == "0" && rHours == "0"){event.value = 1}
if(nDays >=1 && rMinutes == "0" && rHours == "8"){event.value = nDays + .5}
if(nDays >= 1 && rMinutes > 0 && rHours >= 8 ){event.value = nDays + 1};

 

 

1 reply

try67
Community Expert
Community Expert
September 16, 2020

Remove the double-quotes around all the numbers.

rakeshk21205956
Inspiring
September 16, 2020

same thing.. not working as per requirement even after removing the ""

try67
Community Expert
Community Expert
September 16, 2020

Either share the file or be more specific about what "not working" means, exactly...