>
> Confused.
> Are you saying that for a 2.5 hour call you want (upto) 60 minutes
> counted in the hour slot in which the call began and the rest of the
> time you don't want counted at all? So if a 2.5 hour call started at
> 14:55 you would only ever count 5 minutes of the call?


I need to count all time that occurs servicing calls, but for the hour
that in which it occurred. If a Call starts at 11:30:00 and ends at
13:30:00, I need to count the 30 minutes for the 11:00 hour, the 60
minutes for the 12:00 hour and the 30 minutes for the 13:00 hour. This
way I will be collecting ALL time used for each hour in the
appropriate hours that the time servicing occurred in.

Here is an excerpt from a query that shows the result set I would like
to receive from the query:

Month, Hour, Total Elapsed Seconds of Calls Serviced During Row's Hour

January, 0, 123456
January, 1, 123456
.....
January, 31, 123456
February, 1, 123456
....
February, 28, 123456

Comparing this data versus a staff schedule allows you to determine
your efficiency in scheduling vehicles in a logistics company, or in
this case, an EMS service.

Thanks a lot for spending time working through this with me.
Ultimately it will have a great impact on our ability to have
ambulances available at the right times of the day to save people's
lives.

Regards,

Jake