since ‎12-05-2016
‎10-12-2019
ianm863305
Level 1
FormCalc Time Calculations
Avatar

ianm863305

ianm863305
- Adobe LiveCycle
I'm using the below formcalc script to calculate the difference from a start time to a finish time. What I want to see is something like:Start Finish Total 1800 1932 1:32 Using below I get the right amount of minutes but it always shows as a decimal for example 5mins would be .0833333 or 1 hour 5 mins = 1.0833333I have tried everything please help! $ = Abs(Time2Num(Row1.StartTime.formattedValue, "HH:MM") - Time2Num(Row3[0].EndTime.formattedValue, "HH:MM")) / (60*60*1000)Also if possible I need t...

Views

230

Likes

0

Replies

0
How to calculate man hours in repeating table?
Avatar

ianm863305

ianm863305
- Adobe LiveCycle
I'm working with LiveCycle ES3. I have a table that repeats using the built in button of ADD, REMOVE, UP and DOWN. Inside a column of the table I have another table that consists of 4 rows. All are time Fields StartTime, TimeField2, EndTime, and total. I don't need anything to happen with Time Field2. What I would like to see is the total field calculate the total man hours it took to complete that particular job. In addition there is a Checkbox that locks every field in the repeating table exce...

Views

389

Likes

0

Replies

0