I am new to LiveCycle Designer. I am creating a time sheet form that has a table for the following columns: TimeIn, Lunch, TimeOut, TotalTime. The TimeIn and TimeOut cells are formatted as time fields and the lunch field is formatted as a numeric time field. I am trying to get the total amount of hours in my TotalTime numeric field by taking the TimeIn and TimeOut fields and subtracting Lunch. I don't know how to calculate this. Does anyone have any help they can offer me? I know it probably will take JavaScript or FormCal. I don't know these languages. Any help is greatly appreciated. Thank you.
this can be done with FormCalc for example.
I made an example for you, you can start with this.
Time Sheet Sample
radzmar
• LoveCycle Blog
Documents you need:
• LiveCycle Designer ES2 Docs