how sum a sum result?

[Derek]

Hi there
I calculated the time use "=Sum(DateDiff("n",[StartDateTime],[EndDateTime]))" this cell named WorkTime/ I try to sum all workTime valume use =Sum([WorkTime]). But it is not working. the system ask me input value WorkTime?
IS there have any other way to do that?

Thank you

Derek

 

[Rick Brandt]

Hi there
I calculated the time use "=Sum(DateDiff("n",[StartDateTime],[EndDateTime]))"

this cell named WorkTime/ I try to sum all workTime valume use =Sum([WorkTime]).
But it is not working. the system ask me input value WorkTime?

IS there have any other way to do that?

You have to sum the original expression, not the control that holds it.

=Sum(Sum(DateDiff("n",[StartDateTime],[EndDateTime])))