Expand my Community achievements bar.

Enhance your AEM Assets & Boost Your Development: [AEM Gems | June 19, 2024] Improving the Developer Experience with New APIs and Events

Formcalc time calculation

Avatar

Level 1

I'm trying to design a from in adobe livecycle cs2, the from has a table 5 rows,with column "start time" "end time" "hours work" and footer row with column "total time". I need to get for each row hours work answer (end time - start time) no problem, I cant get the hours worked to add up to give me total time answer! Can someboddy please help me

1 Reply

Avatar

Level 1

I am not experienced so much in scripting,

I have table with "Start time", Finish time" and "Working time" columns.

For each row working time is calculated separately and then here is my Formcalc for total time

var t_t = 0

if (Table1.Row[*].Working_time > 0) then

t_t = (Sum(Table1.Row[*].Working_time))

Total_time = Concat(t_t, " h")

else

Total_time = ""

endif