Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Elapsed time over 24 hours

Discussion in 'Information Technology' started by Fast Learner, Jul 28, 2006.

  1. Fast Learner

    Fast Learner
    Expand Collapse
    Guest

    We are trying to make a Database to track trades in our FD Department.
    Fields:
    Name
    Worked for Him
    Worked for Me
    StartTime Ex. (07/13/06 06:45 AM)
    EndTime Ex. (07/14/06 07:00 AM)
    Total Hours Worked
    We take the EndTime-StartTime to get Total Hours Worked but we can't seem to
    get it to give the correct amount of time.What should the fields be formatted
    to? Also we need a Report to show individual totals for time owed or time due
    by each member.
     
  2. Loading...

    Similar Threads Forum Date
    Ashdoc's Movie Review---the Finest Hours Theatre, Movies & Cinema Feb 6, 2016
    about 8 hours! Blogs Oct 16, 2015
    Punjab entrepreneur sets up 10-storey building in Mohali in 48 hours Punjab, Punjabi, Punjabiyat Dec 3, 2012
    Kindly put some light on final hours of Guru Gobind Singh Jee's Human Life. Sikh Sikhi Sikhism Jul 29, 2012
    Bhagat Singh's Final Hours History of Sikhism Oct 14, 2011

  3. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    The Date/Time data type is intended for timestamps (i.e.: specific date/time
    points in time) as opposed to durations.

    Reallistically, you should figure out what granularity you need for your
    time duration (minutes? seconds?) and use DateDiff to figure out the
    duration in those units. You can write a function to convert from, say,
    total minutes to total hours and minutes.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "Fast Learner" <FastLearner@discussions.microsoft.com> wrote in message
    news:3218737E-D700-48DB-BC68-5FBBD726D449@microsoft.com...
    > We are trying to make a Database to track trades in our FD Department.
    > Fields:
    > Name
    > Worked for Him
    > Worked for Me
    > StartTime Ex. (07/13/06 06:45 AM)
    > EndTime Ex. (07/14/06 07:00 AM)
    > Total Hours Worked
    > We take the EndTime-StartTime to get Total Hours Worked but we can't seem
    > to
    > get it to give the correct amount of time.What should the fields be
    > formatted
    > to? Also we need a Report to show individual totals for time owed or time
    > due
    > by each member.
    >
     

Share This Page