These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Time calculation on a time card application

Forum Index > Forms: Acrobat > Time calculation on a time card application
2008-12-04 11:08:42
dlinder
Registered: Dec 4 2008
Posts: 3

I have an Excel time card setup currently that I would like to make into a PDF form. The total hour for each day are calculated then added up for the week. The daily calculation looks like this in Excel =MROUND(((E20-D20)+(G20-F20)+(I20-H20))*24,0.25). Each of the values is the in and out times for the day.

How would I go about doing this calculation in a form?

My Product Information:
Acrobat Pro 8.1, Windows
Top
2008-12-04 13:16:30
#1
gkaiseril
Expert
Registered: Feb 23 2006
Posts: 4307
Are you going to use Acrobat Forms or LiveCycle Designer. Both have time date objects.

Have you read the 3 part series by Thom Parker on date calculations in Acrobat?

If you are using LiveCycle Designer, there is information in the "Scripting Reference" under 'Help".

Both products use the number o milliseconds from a fixed Epoch date, so once you get the time string converted to a number, you just need to do the math. You will need to write your own MROUND function because neither Acrobat nor LiveCycle Designer have that function built in.

George Kaiser

Top