Calculating time on a time card

G

Guest

I have a problem and was hoping somebody could assist me. I am trying to
calculate the time it takes (in hrs) to manufacture certain items. I have a
start date and time and a end date and time. It can sometimes take a few days
to manufacture a group of items , so only work days can be considered. I also
need take into consideration that an average working day consists of 8.00 hrs
It starts at 7.30am and finishes at 16.30pm. In a day there are two
production breaks of 15min each (10.30-10.45 and 15.00-15.15) and one
production break of 30min ( 12.30-13.00). In order to accurately get a
production time I need to only consider work days , and only consider work
hours or part thereof. How can I do this ????

An example would be :

Start Date 04.01.2005
Start Time 09.00
End Date 10.01.2005
End Time 12.00

I should get a result of 35hrs production time
ie 6.30 on the starting day
8hrs on the 5th 6th and 7th
and 4.30 on the end date 10th,
Only work hrs are considered anf the weekend of the 8th and 9th have also
been excluded.

Please help ....anybody.
Thanks
Kevin
 
T

Tom Wickerath

Hi Kevin,

This should get you started:

Doing WorkDay Math in VBA
http://www.mvps.org/access/datetime/date0012.htm

It should allow you to calculate the number of working days between two dates, with weekends
excluded. You'll need to include company holidays in a table, which can be used to populate an
array, in order to have these days excluded. You'll still need to work out the code for the rest
of the procedure, to take into account your break times.


Tom
_________________________________


I have a problem and was hoping somebody could assist me. I am trying to
calculate the time it takes (in hrs) to manufacture certain items. I have a
start date and time and a end date and time. It can sometimes take a few days
to manufacture a group of items , so only work days can be considered. I also
need take into consideration that an average working day consists of 8.00 hrs
It starts at 7.30am and finishes at 16.30pm. In a day there are two
production breaks of 15min each (10.30-10.45 and 15.00-15.15) and one
production break of 30min ( 12.30-13.00). In order to accurately get a
production time I need to only consider work days , and only consider work
hours or part thereof. How can I do this ????

An example would be :

Start Date 04.01.2005
Start Time 09.00
End Date 10.01.2005
End Time 12.00

I should get a result of 35hrs production time
ie 6.30 on the starting day
8hrs on the 5th 6th and 7th
and 4.30 on the end date 10th,
Only work hrs are considered anf the weekend of the 8th and 9th have also
been excluded.

Please help ....anybody.
Thanks
Kevin
 

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

Top