K
Kevin
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
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