i need this to happen automatically startshutdowndifference (decimal hours)12:3412:440.2 hours13:0013:210.4 hours13:4015:011.4 hours

Participating Frequently

Question

how to calculate time difference between two field and give the answer in a third one using decimal hours

Forum|Forum|7 years ago
March 7, 2018
2 replies
878 views

i need this to happen automatically

start	shutdown	difference (decimal hours)
12:34	12:44	0.2 hours
13:00	13:21	0.4 hours
13:40	15:01	1.4 hours

Acrobat SDK and JavaScript

This topic has been closed for replies.

G

gkaiseril

Inspiring

There are some additional issues you need to provide information about.

1. Will the time interval ever span more than 1 date?

If so, you will need to include the dates for the start and end.

2. You are rounding to the nearest 1/10th of an hour, since JavaScript uses IEEE floating point to store numbers, you will need to provide a rounding routine for the floating point number unless you can live with the fractional values in the result beyond 1/10th of an hour.

P

patrickc26905363Author

Participating Frequently

time will always span on the same day/date

and

we have predetermined time decimals ex:

from 1 to 6 = 0.1

from 6 to 14= 0.2

from 15 to 20=0.3

.....

G

gkaiseril

Inspiring

With only hours an minutes, this calculation will not work when the interval includes the time changes due to Day Light Saving Time, British Summer Time, or other adjustment to local time to adjust for the hours of daylight. If the date is included JavaScript will automatically adjust for the 1 hour change in the local time.