Calculating times

[thare]

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

 

[Chris Davison]

sounds like a rounding problem...

*takes a bow for the most obvious statement of the day*

seriously though, it might be better if you post some concrete examples of the data you are working with, including all the formulae, assuming your deadline hasn't already passed