Lookup Hours from table based on date range...
Thanks in advance!
Basics: - large raw data table w/ 2 date fields (start & end) amongst lots of other data - there's a field that totals the time for process from start to end - there's also a field with an equipment number for that line item - 2nd large data table w/ engineering/offline time information for each piece of equipment for each day (hours per equip# per date) I need to come up with a formula or macro to take out the engineering/offline time from the process time for each line item in the large raw data table. Ex: start = 1/1/2006 00:00 ; end = 1/5/2006 00:00 ; total = 96:00 hours engineering/offline : 1/1/2006 = 12 hours ; 1/2/2006 = 6 hours ; 1/3/2006 = 6 hours ; 1/4/2006 = 12 hours Total = 36 hours I need to be able show that for this line item in the raw data table that the applicable time is 60 hours (96 - 36). I'm stumped! thanks again. |
All times are GMT +1. The time now is 07:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com