dollarbill
Programmer
Following is an example of my cross-tab:
Week 1 Week 2 Week 3
Doe, John
incoming 45 57 49
duration 180920 176543 169233
outgoing 11 22 33
Smith, Jim
incoming 47 59 51
duration 180922 176545 169235
outgoing 13 24 37
Jones, Bill
incoming 49 61 53
duration 180924 176547 169237
outgoing 15 26 39
My problem is that the duration is shown in seconds and we need to convert it to hours, minutes, seconds. We have a function that will perform this for us, however in the cross-tab it is a sum for the week. So if we convert the duration before it is summed, then we get an incorrect sum, because of the time element. And we cannot find a way to use our function after the sum has been performed. Any help would be appreciated.
Thanks!
Week 1 Week 2 Week 3
Doe, John
incoming 45 57 49
duration 180920 176543 169233
outgoing 11 22 33
Smith, Jim
incoming 47 59 51
duration 180922 176545 169235
outgoing 13 24 37
Jones, Bill
incoming 49 61 53
duration 180924 176547 169237
outgoing 15 26 39
My problem is that the duration is shown in seconds and we need to convert it to hours, minutes, seconds. We have a function that will perform this for us, however in the cross-tab it is a sum for the week. So if we convert the duration before it is summed, then we get an incorrect sum, because of the time element. And we cannot find a way to use our function after the sum has been performed. Any help would be appreciated.
Thanks!