try putting your code in the calculate event

The result should be the number of hours/minutes difference - but yes with that pattern it shows as a time.To make sure the end time is after the start time use Time2Num for both and then make sure the number of the end time is larger than the number of the start time.

You would use the functions Time2Num and Num2GMTime to do this. In the calculate event of the total time field you would put something like (in formcalc):var startT = StartTime.formattedValuevar endT = EndTime.formattedValuevar differenceT = Time2Num(endT, "HH:MM:SS") - Time2Num(startT, "HH:MM:SS")$...

If Limbo1, Limbo2 etc are in the same dropdown and you want them to do the same thing then just add them to if statement:if(this.rawValue == "Limbo" || this.rawValue == "Limbo 1" || this.rawValue == "Limbo 2")

It is probably best to use a numeric field rather than a text field if you only want numbers but either way you can put in the exit event of the field (in formcalc):if ($ < 3) thenxfa.host.messageBox("The value cannot be less than 3")$ = ""endif

In formcalc the function Avg will calculate the average of only the fields with a value in them. So you would would put in the calcuate event of the average field:$ = Avg(Q1S1,Q1S2,Q1S3,Q1S4, etc)

you need to put "Sum()" around Table2.Row1[*].staffrequired as you have for shortdays

you would put it in an event (such as the click event) for the text you want to hyperlink

Can I suggest trying the code the other way around. So in the masterpage footer put something like (in formcalc):if (Page1.title.isnull == 0) then$ = Page1.titleelse $ = ""endif- obviously changing the name of Page1.title to whatever your field is called. You can put that in the layoutReady event of...

you can use:xfa.host.setFocus("placeYouWantToGo")to move about within the document