Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Calculating times

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ::

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •