Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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.
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page