To measure the cycle time between similar transactions

eramzan

New Member
Joined
Mar 1, 2012
Messages
2
Hi,

I need a measure that allows me to measure the cycle time between similar transactions.
I have a data table with a list of transactions that I would like to be able to calculate the time from the last transaction of the same type. The columns of data would include transaction types, product information, project names, and transaction date. I want to be able to pivot on the project name, time frame, and the transaction type and find the average cycle time between transactions.
Please Help.

Regards:
Muhammad Ehsan
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

powerpivotpro

Board Regular
Joined
Jan 18, 2012
Messages
242
Would love to help with this problem, but can you give us a little more detail of what your data looks like?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,738
Messages
5,524,549
Members
409,584
Latest member
Devil_717

This Week's Hot Topics

Top