Calculating times

thare · Apr 8th, 2002, 06:56 PM

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 · Apr 9th, 2002, 02:02 PM

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

Apr 9th, 2002, 02:02 PM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	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 __________________ :: Pharma Z - Family drugstore ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 8th, 2002, 06:56 PM	#1
thare New Member Join Date: Apr 2002 Posts: 13	ROUND((AC5-AD5)(-243600),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 ]