On 6 Feb, 16:26, steven...@gmail.com wrote:
> > 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

A couple of posts ago, I said "So a call that lasted 2.5 hours would
appear in three of the hourly slots?"
Your reply in the following post was "No"

Now you are saying "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."

Which is what I said and you said no to!