P
pcslave via AccessMonster.com
I've been given an excel work book with 34 worksheets where each worksheet
represents one month beginning with Jan '04. Each worksheets represents the
start/stop time of required daily routines. The format of each worksheet is:
SOEOD POEOD
Start 11/1/06 2:48 AM 11/1/06 3:10 AM
Stop 11/1/06 3:10 AM 11/1/06 3:43 AM
Total 0:22:20 0:32:46
Start 11/2/06 2:36 AM 11/2/06 3:00 AM
Stop 11/2/06 3:00 AM 11/2/06 3:33 AM
Total 0:24:13 0:32:39
Where each entry is in a separate cell. The total is computed by subtracting
the start time from the stop time. There are 6 more columns, one for Backup,
Build Allocation, Build Print Out, Total Time for Report, Total Time for the
Entire Process and comments.
The Total Time for Report is computed by adding the Total row for Build
Allocation and Build Print Out. The Total Time for the Entire Process is
computed by adding the Total row for SOEOD, POEOD, Backup and Total Time for
Report.
What I want to do is to import only the Start and Stop date/time for each
event (SOEOD, POEOD, Backup, Build Allocation, Build Print Out and comment.
I will then use Access to compute total times per event and total time for
entire process. Eventually, I want to build a form to allow the data entry
clerk to just enter the date and time per event (in 24 hour clock format). I
will then build various queries to compare totals per event per day of week,
totals per event per week, etc., depending on what data management wants.
When I tried to import each worksheet, I of couse get everything, then have
to delete total data, etc. I had thought that each event would start and
stop time would have it's own field.
Please provide any recommendations that may help.
Thanks
represents one month beginning with Jan '04. Each worksheets represents the
start/stop time of required daily routines. The format of each worksheet is:
SOEOD POEOD
Start 11/1/06 2:48 AM 11/1/06 3:10 AM
Stop 11/1/06 3:10 AM 11/1/06 3:43 AM
Total 0:22:20 0:32:46
Start 11/2/06 2:36 AM 11/2/06 3:00 AM
Stop 11/2/06 3:00 AM 11/2/06 3:33 AM
Total 0:24:13 0:32:39
Where each entry is in a separate cell. The total is computed by subtracting
the start time from the stop time. There are 6 more columns, one for Backup,
Build Allocation, Build Print Out, Total Time for Report, Total Time for the
Entire Process and comments.
The Total Time for Report is computed by adding the Total row for Build
Allocation and Build Print Out. The Total Time for the Entire Process is
computed by adding the Total row for SOEOD, POEOD, Backup and Total Time for
Report.
What I want to do is to import only the Start and Stop date/time for each
event (SOEOD, POEOD, Backup, Build Allocation, Build Print Out and comment.
I will then use Access to compute total times per event and total time for
entire process. Eventually, I want to build a form to allow the data entry
clerk to just enter the date and time per event (in 24 hour clock format). I
will then build various queries to compare totals per event per day of week,
totals per event per week, etc., depending on what data management wants.
When I tried to import each worksheet, I of couse get everything, then have
to delete total data, etc. I had thought that each event would start and
stop time would have it's own field.
Please provide any recommendations that may help.
Thanks