Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return info based on Date Range | Excel Worksheet Functions | |||
Bucketing data based on DATE Range criteria | Excel Discussion (Misc queries) | |||
Crate group of date, with Dynamic Range in pivot table not working | Excel Discussion (Misc queries) | |||
Value between 2 dates | Excel Worksheet Functions | |||
In Excel 2003 how do you get a table to update based on lookup cr. | Excel Worksheet Functions |