Skip to main content
rakeshk21205956
Inspiring
Sep 16, 2020 10:21 AM UTC
Answered

Adobe Acrobat Forms : Add a specific number at specific interval

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 is closed to new replies. Start a new post to keep the conversation going.
rakeshk21205956
rakeshk21205956Correct answer
Inspiring
Sep 18, 2020 11:43 AM UTC

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};

 

 

7 replies

try67
Community Expert
Community Expert
Sep 16, 2020 3:52 PM UTC

Remove the double-quotes around all the numbers.

Translate
rakeshk21205956
Inspiring
Sep 16, 2020 4:43 PM UTC

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

Translate
try67
Community Expert
Community Expert
Sep 16, 2020 9:31 PM UTC

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

Translate