# FormCalc

Hi!

I've been trying to add time fields using Formcalc with no success. I was wondering if someone could help me... This is getting really frustrating.

After a lot of trial and error I ended up with this piece of code:

if (tPausa ne null and tPausa > 0) then

totalLinhaRelatorio.formattedValue = Num2Time(tOut - tIn - tPausa - 158400000, "HH:MM")

else

totalLinhaRelatorio.formattedValue = Num2Time(tOut - tIn - 79200000, "HH:MM")

endif

It basicaly calculates time spent on a task, considering start and end times and some time off, if there is any.

I have no idea why I have to subtract 158400000 OR 79200000 from the result to get the correct time. I only know it works.

Now, as this is a dynamic table, I must add the results to a variable to calculate the final total.

So I tried this:

if (tOut ne null and tOut > 0) then

if (tPausa ne null and tPausa > 0) then

totalLinhaRelatorio.formattedValue = Num2Time(tOut - tIn - tPausa - 158400000, "HH:MM")

finalTotal = finalTotal + tOut - tIn

form1.RATForm.parteInferior.totalGeral.formattedValue = Num2Time(finalTotal - 79200000, "HH:MM")

totalLinhaRelatorio.formattedValue = Num2Time(tOut - tIn - 79200000, "HH:MM")

else

totalLinhaRelatorio.formattedValue = Num2Time(tOut - tIn - 79200000, "HH:MM")

finalTotal = finalTotal + tOut - tIn

form1.RATForm.parteInferior.totalGeral.formattedValue = Num2Time(finalTotal - 79200000, "HH:MM")

totalLinhaRelatorio.formattedValue = Num2Time(tOut - tIn - 79200000, "HH:MM")

endif

endif

Now this one doesn't work. It returns the correct value on the very first entry. Then all results for totalGeral are absolutely nonsense and doesn't seem to follow any pattern, so I'm  clueless.

Thank you!!

Marcos