Cumulative Time in Pivot Table

[#1]

I have a Pivot Table which displays minutes for every job. I have converted minutes into time through MakeTime function and starting from 6:00 AM. Here is the layout:

JOB Minutes Time

1 45 6:45 AM

2 60 7:00 AM

3 45 6:45 AM

Now I want to display the time by adding the minutes into it. Like this:

JOB Minutes Time

1 45 6:45 AM

2 60 7:45 AM

3 45 8:30 AM

Any suggestions would be appreciated.

Thanks a lot!!!

[stephencredmond]

Hi,

Use a combination of RangeSum and Above. E.g.

Time( Num(Time(StartTime)) + (RangeSum(Above(Sum(Mins),0,RowNo()))/(60*24)))

Stephen

[#3]

Thanks Stephen, it works like a charm!!!