summing call durations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column that holds the duration of calls (duration) in which I'm
trying to sum per ext: ie:104

the current format is hh:mm:ss and the column would look something like this:

00:00:21
00:04:46
00:00:35

I've tried to do a running sum. When I put the control box in and make the
control source =sum([duration]) it takes it ok when I put in the format as
hh:mm:ss it changes it to hh:nn:ss (what is nn) anyway, the first line sum
comes to 0:01:03? How is that when it should be 00:00:21.

Bottom line I apperantly don't have any clue what I'm doing. I don't know
if running sum is what I really need the report is grouping already if I
could just show the bottom line for each ext that would be ok as well. Could
someone help me. Note this should show total time that the person was on the
phone.

Thanks,

ScottP
 
tri_p said:
I have a column that holds the duration of calls (duration) in which I'm
trying to sum per ext: ie:104

the current format is hh:mm:ss and the column would look something like this:

00:00:21
00:04:46
00:00:35

I've tried to do a running sum. When I put the control box in and make the
control source =sum([duration]) it takes it ok when I put in the format as
hh:mm:ss it changes it to hh:nn:ss (what is nn) anyway, the first line sum
comes to 0:01:03? How is that when it should be 00:00:21.

Bottom line I apperantly don't have any clue what I'm doing. I don't know
if running sum is what I really need the report is grouping already if I
could just show the bottom line for each ext that would be ok as well. Could
someone help me. Note this should show total time that the person was on the
phone.
Click to expand...


I think I tried to answer this question in some other
newsgroup.
 
tri_p said:
I have a column that holds the duration of calls (duration) in which I'm
trying to sum per ext: ie:104

the current format is hh:mm:ss and the column would look something like this:

00:00:21
00:04:46
00:00:35

I've tried to do a running sum. When I put the control box in and make the
control source =sum([duration]) it takes it ok when I put in the format as
hh:mm:ss it changes it to hh:nn:ss (what is nn) anyway, the first line sum
comes to 0:01:03? How is that when it should be 00:00:21.

Bottom line I apperantly don't have any clue what I'm doing. I don't know
if running sum is what I really need the report is grouping already if I
could just show the bottom line for each ext that would be ok as well. Could
someone help me. Note this should show total time that the person was on the
phone.
Click to expand...
Click to expand...

Ok, we'll keep this thread going. However, what I said in
the other thread is still applicable. I really don't think
you have a use for RunningSum with this situation so try
clearing that property.

Are you sure the duration values are Date/Time type and not
a number or text type? Note that how it looks is strictly
how it's formatted, not the underlying data type. I don't
see how you could get 0:01:03 so I'm still wondering where
these values are coming from.

The nn in the format is minutes, mm is used for months.
 
Back
Top