#1
|
|||
|
|||
Reporting Machine Usage
I have an excel file (sample attached) that reports the start and stop time that various machines are in use. I need to be able to report on the amount of time that multiple machines are in use.
For example, if I had 10 machines I would need to report on the total amount of time that no machine is in use, only 1 machine is in use, 2 machines are in use,..., all 10 machines are in use. I've found a time consuming, complicated way to do in involving an excellerated running clock and a series of vlookups but, as my machine counts could be as high as 30 and a period of usage over a year or so, I would have to leave my computer running for a week! I'm hoping there is an easier way to report on these overlapping time periods. Thanks in advance |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Reporting Values Between Sheets/Tabs | jjbNana | Excel | 3 | 10-06-2011 10:28 PM |
Resource Overallocation Reporting | Mutso | Project | 0 | 11-05-2010 12:27 PM |
Outlook reporting from mail merge?? | jondoyle24 | Outlook | 0 | 10-18-2010 06:44 AM |
Project Reporting | vickib1 | Project | 0 | 09-08-2010 03:11 AM |
unable to open .RTF files in server machine from client machine | Naresh_1210 | Word | 0 | 03-12-2010 03:26 AM |