I need to generate a report that shows equipment utilization over a time period. Given a period of days and the times of interest how many times was all the equipment in use and for how long each occurrence.
I have a database in which I have tracked on what days a piece of equipment was used, when it started and when it finished. Now all I need is a way to show how many were busy at any one time. Any ideas on how to go about it?
I have a database in which I have tracked on what days a piece of equipment was used, when it started and when it finished. Now all I need is a way to show how many were busy at any one time. Any ideas on how to go about it?