I can collect the hour meter readings via DDE directly from our equipment along with the datetime and the machine id. What is a good way to report on the run time for each week verses the elapsed time.

Machine Sched Hours Actual Hours Utilization
A1 40 36 90%
A2 40 24 60%


Should I try and collect the data shift by shift and the convert that into hours ran that shift?

Any ideas will help

Thanks