how sum a sum result?

D

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
 
R

Rick Brandt

Derek said:
Hi there
I calculated the time use "=Sum(DateDiff("n",[StartDateTime],[EndDateTime]))"
Click to expand...
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?
Click to expand...

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

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