Calculate elapsed time excluding time for breaks, lunch, etc

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
SJR@mbci said:
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.
Click to expand...

Try the following thread from CDMA:

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

James A. Fortune
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Calculated minus breaks & lunch 2
Calculate elapsed time excluding specific timeframe 10
elapsed time calculation 6
Time Calculations 1
Calculating elapsed time 2
Calculating time 5
storing and using elapsed time data 2
calculate time elapsed inbetween days 3

Back
Top