Time Calculation

[edssoftware01]

Good Afternoon All Professional,

Would need your professional information as below table i have create in adobe reader.

the calculation of Total Hrs as below "3rd screenshot"

what i want is as below:-

3.15 change to 3.25

2.45 change to 2.75

5.30 change to 5.50

the actual calculation is

9:15pm = 21:15 hrs = 1260min + 15min = 1275min

6:00pm = 18:00 hrs = 1080 min

1275min - 1080min = 195 min

195 / 60 = 3.25

do any can give me a code to solve it?

Many thanks for all of you.

[try67]

So you have a code that calculates the time difference but the result is in decimals (3.25) and you want to convert it to a time notation (3:15)?

[edssoftware01]

i want

3.15 to 3.25

3.30 to 3.50

3.45 to 3.75

is it possible to do in javascript?

[try67]

I see... Can you post your original code?

[edssoftware01]

my code is only use

(ToSUN-FromSUN)+(ToSUN_2-FromSUN_2)

at Simplified field notation:

[try67]

That code won't work with time fields in the format you've shown.

[edssoftware01]

for me it can work, but the only thing is need to change as i mention just now.

or how can i send attach the pdf file for you o refer?

[try67]

Yes, please share the file via Dropbox, Google Drive, Adobe Cloud, etc. You can also email it to me directly (try6767 at gmail.com), if you wish.

[edssoftware01]

Have send many thanks for help

[edssoftware01]

Morning try67,

have any solution after receive my PDF files?

[try67]

Yes, and I replied by email.

[gkaiseril]

If you want the elapsed time in decimal hours rather than hours and minutes, you would need to enter the time in decimal hours and not hours and minutes.

Do not forget that in some areas of the world there is a change to and from Day Light Savings time and back to Standard time, and if the time interval being measured includes the time change event one hour is lost in the spring and one hour is added in the fall. This also means you need to account for the date for which the time interval is being computed.

[edssoftware01]

i cannot use time in decimal, because my use need to use hours and minutes, the only thing i can imagination is use split hour and minute command, then formula is (hrs * 60) + min

but i can found any code can use in adobe. I'm new in java coding.