Solved How can i work out the difference in timestamps?

April 12, 2015 at 08:05:29
Specs: Windows 64
Excel - How do i count the difference in time stamps?

Column A - Account number
Column B - Payment amount
Column C - Timestamp

Lets say I have 12 customers, each of those customers (over the course of a year, whatever) will pay a random amount, on a random date, no set pattern what so ever really.

What I'm looking to do is work out the average gap in time that each of them pay.

I cannot just sum 1 time stamp from the one before it, as they could relate to different accounts.

Any help is much appreciated.

See More: How can i work out the difference in timestamps?

Report •

April 13, 2015 at 13:02:43
✔ Best Answer
The quickest way would be to first Sort your data on Column A - Account Number
with a Secondary Sort on Column C your Time.

Then it just a matter of subtracting the Times.
Once you have that data then do your Averages


Report •
Related Solutions

Ask Question