6 Replies Latest reply on May 14, 2017 11:49 AM by gkaiseril

# calculate total hours between two date fields and two time fields

Hi All.

In my PDF form I would like to calculate total hours between two date fields StartDate and EndDate which formatted like m/d/yyyy. And two time fields StartTime and EndTime which formatted like HH:MM. If StartDate and EndDate are the same so total hours between = 0. If startDate and EndDate are different (5/10/2017 and 5/11/2017) so Total = 7.

For instance:

StartDateEndDateStartTime
EndTimeTotal
5/10/20175/10/201709:0013:004:00
5/10/20175/11/201709:0015:3012:30

How to solve that problem?

Thanks.

• ###### 1. Re: calculate total hours between two date fields and two time fields

I have a free Date library for ACrobat that has a "daysBetween" method that will make that calculation easier.

• ###### 2. Re: calculate total hours between two date fields and two time fields

Doesn't it only do date calculations, not time ones?

• ###### 3. Re: calculate total hours between two date fields and two time fields

It has elapsed time as well. From there you can get hours.

• ###### 4. Re: calculate total hours between two date fields and two time fields

Neat!

• ###### 5. Re: calculate total hours between two date fields and two time fields

I found code and modified it for my task

var cEnd = this.getField("EndDate").value

var cStart = this.getField("StartDate").value;

if(cEnd != "" & cStart != "")

{

var oEnd = util.scand("m/d/yyyy", cEnd);

var oStart =util.scand("m/d/yyyy", cStart);

var nEnd = Math.floor(Number(oEnd) / (1000 * 60 * 60));

var nStart = Math.floor(Number(oStart) / (1000 * 60 * 60));

event.value = nEnd - nStart;

}

My problem now how to calculate:

- If StartDate and EndDate are the same so total hours between = 0.

- If startDate and EndDate are different (5/10/2017 and 5/11/2017)  Result = 7.

(5/10/2017 and 5/12/2017)  Result = 14

and so on.

Thanks.

• ###### 6. Re: calculate total hours between two date fields and two time fields

It is not clear how one gets a value of 7 when the start and end dates are the same. Does the start and end time have any affect on the result?

The same applies if the start and end date are different. What happens if the dates are more than 2 days different?