how sum a sum result?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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])))
 
Back
Top