[RESOLVED] After Update ,Total Hours Only Calculate 2 fields instead of 4 fields why?

[MarkT]

For the set, you may want to try something like this.

SET [EnterTotal]=DateDiff(""n"", [EnterIn],[EnterOut]) + DateDiff(""n"", [EnterIN1],[EnterOut2])