I want to get hourly usage from a database this is to help check efficiency
of machinery. At present I have a speadsheet that returns amount of units
left to produce and other usefull information but would like to be able to
get an hourly units produced per machine. This will help target slower
running machines.
At present I use a SQL query to pull information in real time from database.
Can I use another SQL sdtaement or is there a formulae that will only pull
the information within specific time frame. ie form 06:00 to 07:00 first
hour then from 07:00 to 08:00 etc. all I wish back from this data is units
produced per machine per hour.