Welcome to SPN

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

Sign Up Now!

Calculate elapsed time excluding time for breaks, lunch, etc

Discussion in 'Information Technology' started by SJR@mbci, Jul 28, 2006.

  1. SJR@mbci

    SJR@mbci
    Expand Collapse
    Guest

    I would like to calculate the number of minutes elapsed between time1 and
    time2 excluding time for breaks, lunch, between shifts, etc. I have searched
    this site and found a lot of solutions for excluding "days" (like weekends)
    from time calculations, but none that address how to exclude periods of time
    less than a day.

    I'm sure the solution will involve a table to hold the time periods to
    exclude and a lot of code to do the calculations. I'm hoping that someone
    can direct me to a wesite that can address this situation.

    Thanks in advance.
     
  2. Loading...

    Similar Threads Forum Date
    India Reading Calculated Banis Breaking News Mar 6, 2013

  3. James A. Fortune

    James A. Fortune
    Expand Collapse
    Guest

    SJR@mbci wrote:
    > I would like to calculate the number of minutes elapsed between time1 and
    > time2 excluding time for breaks, lunch, between shifts, etc. I have searched
    > this site and found a lot of solutions for excluding "days" (like weekends)
    > from time calculations, but none that address how to exclude periods of time
    > less than a day.
    >
    > I'm sure the solution will involve a table to hold the time periods to
    > exclude and a lot of code to do the calculations. I'm hoping that someone
    > can direct me to a wesite that can address this situation.
    >
    > Thanks in advance.


    Try the following thread from CDMA:

    http://groups.google.com/group/comp...556dde02b88/948a5c4e14d10ab7#948a5c4e14d10ab7

    James A. Fortune
    MPAPoster@FortuneJames.com
     
  4. SJR@mbci

    SJR@mbci
    Expand Collapse
    Guest

    Exactly what I need. Thanks for your help!

    "James A. Fortune" wrote:

    > SJR@mbci wrote:
    > > I would like to calculate the number of minutes elapsed between time1 and
    > > time2 excluding time for breaks, lunch, between shifts, etc. I have searched
    > > this site and found a lot of solutions for excluding "days" (like weekends)
    > > from time calculations, but none that address how to exclude periods of time
    > > less than a day.
    > >
    > > I'm sure the solution will involve a table to hold the time periods to
    > > exclude and a lot of code to do the calculations. I'm hoping that someone
    > > can direct me to a wesite that can address this situation.
    > >
    > > Thanks in advance.

    >
    > Try the following thread from CDMA:
    >
    > http://groups.google.com/group/comp...556dde02b88/948a5c4e14d10ab7#948a5c4e14d10ab7
    >
    > James A. Fortune
    > MPAPoster@FortuneJames.com
    >
     

Share This Page