Need to be able segregate units run in excel sheet using time.

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have a spread*** that gets data from using an SQL statement this is
updated with a macro and button so it can be refreshed at any time as this
info is time critical.

I want to be able to separate the units ran within an hour by filler and
unit size.
I know how to do the above but can't find any info on how to download info
by the hour.
ie need to know how many units ran from 06:00 to 07:00.
When looking at the info from the database I can't find any reference to time.

I am not an expert on SQL or Macros so need help.

Can I use a macro to retrieve the data by the hour and if so how.
Would it be better to extend my SQL statement is so how.


.

Quantcast