ROUND((AC5-AD5)*(-24*3600),0)
Hi Folks:
I am using the above formula basically to change elapse time (e.g. start=9:01:00 finish=9:02:30) to penalties/points of the same value (i.e. elapse:1min 30secs = 90points). Noting that I have approximately six(6) sets of columns per session. To arrive at the total penalties/points per session I am adding together the six(6) results in a separate column (using a sum formula), however when that is done I am realizing a 3 increment increase in the computer's total as oppose to my manual addition which is correct.
What can I do to change this? Need help urgent.
This message was edited by thare on 2002-04-09 06:30
Hi Folks:
I am using the above formula basically to change elapse time (e.g. start=9:01:00 finish=9:02:30) to penalties/points of the same value (i.e. elapse:1min 30secs = 90points). Noting that I have approximately six(6) sets of columns per session. To arrive at the total penalties/points per session I am adding together the six(6) results in a separate column (using a sum formula), however when that is done I am realizing a 3 increment increase in the computer's total as oppose to my manual addition which is correct.
What can I do to change this? Need help urgent.
This message was edited by thare on 2002-04-09 06:30