G
Guest
I have a table that has 5 fields:
ID, AutoNumber
Ticket, Number
Techs, Number
Start, Date/Time
Stop, Date/Time
I built 3 seperate queries that output the below information
qryJob:
ID Ticket# Techs Start Stop TotalMH
1 A123 1 8/12/05 9:00 8/12/05 11:00 2.00
2 A123 2 8/12/05 9:00 8/12/05 12:00 6.00
3 A123 1 8/12/05 14:00 8/12/05 18:00 2.00
4 A123 1 8/13/05 9:00 8/13/05 11:00 2.00
I built another query that calculates the Total Man Hours for each ticket
qryJobMH:
Ticket# TotalMH
A123 14.00
I also have yet another query that calculates the total elapsed time
qryJobElpsd:
Ticket# TotalElpsd
A123 26.00
I REALLY REALLY NEED HELP WITH a query that will output the below information
Ticket# CrazyTotal
A123 9.00
This is essentially total elapsed time this ticket was being worked on.
Earliest start time on 8/12 is 9:00 and then the latest end time for that bit
of overlap is 12:00 which is 3 hours. Then we have a gap of 2 hours and work
again from 14:00 to 18:00 which is an additional 4. The next day we work from
9:00 to 11:00 which is another 2. Add them up and we get 9.00 hours.
Any takers?
TIA!!!!
John G.
ID, AutoNumber
Ticket, Number
Techs, Number
Start, Date/Time
Stop, Date/Time
I built 3 seperate queries that output the below information
qryJob:
ID Ticket# Techs Start Stop TotalMH
1 A123 1 8/12/05 9:00 8/12/05 11:00 2.00
2 A123 2 8/12/05 9:00 8/12/05 12:00 6.00
3 A123 1 8/12/05 14:00 8/12/05 18:00 2.00
4 A123 1 8/13/05 9:00 8/13/05 11:00 2.00
I built another query that calculates the Total Man Hours for each ticket
qryJobMH:
Ticket# TotalMH
A123 14.00
I also have yet another query that calculates the total elapsed time
qryJobElpsd:
Ticket# TotalElpsd
A123 26.00
I REALLY REALLY NEED HELP WITH a query that will output the below information
Ticket# CrazyTotal
A123 9.00
This is essentially total elapsed time this ticket was being worked on.
Earliest start time on 8/12 is 9:00 and then the latest end time for that bit
of overlap is 12:00 which is 3 hours. Then we have a gap of 2 hours and work
again from 14:00 to 18:00 which is an additional 4. The next day we work from
9:00 to 11:00 which is another 2. Add them up and we get 9.00 hours.
Any takers?
TIA!!!!
John G.