Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    Australia
    Posts
    5

    Red face Unanswered: summing time field

    I am trying to sum a time field on a report which comes from a table.
    When I do a break down of the individual times it shows:

    0.30
    1.30
    0.15

    But when I go to sum this field on the report the total time shows:
    1.75 instead of 2.15

    Obviously, it is not calculating these values as times, so how do I format it so that it does?

    Thanks in advance

    Corinne

  2. #2
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    Lightbulb finaly i've got it

    What you have to do is the following


    First calc the value before your dot (.)
    this will be the Hours (for now !!!)
    so

    0.30
    1.30
    0.15
    H=1

    Now sum the value after the dot
    if this is higher then or = 60
    you have to devid it by 60
    so M = 75 / 60 =1,25

    Add the hole number to the hours
    if this give you an point (see up )
    multiply 0,25 by 60 this will give 15

    so your total time will be 2.15 hours

    How you want to do this is up to you (code or SQL)

    -^.^-

  3. #3
    Join Date
    Nov 2003
    Location
    Australia
    Posts
    5

    Re: finaly i've got it

    Ohh...that sounds good..
    Can you show me both the sql and the coding?

    Thanks

    Originally posted by Marvels
    What you have to do is the following


    First calc the value before your dot (.)
    this will be the Hours (for now !!!)
    so

    0.30
    1.30
    0.15
    H=1

    Now sum the value after the dot
    if this is higher then or = 60
    you have to devid it by 60
    so M = 75 / 60 =1,25

    Add the hole number to the hours
    if this give you an point (see up )
    multiply 0,25 by 60 this will give 15

    so your total time will be 2.15 hours

    How you want to do this is up to you (code or SQL)

    -^.^-

Posting Permissions

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