JimS
07-27-2009, 10:10 AM
I have a column of Time Stamps that are formated with mm/dd/yyyy hh:mm:ss.
The Time Stamps start in cell A4 and can have varying number of entries in column A.
I need to determine 2 things:
1) What is the average difference for all the Time Stamps. I'm trying to detemine what the average time in seconds is between all the Time Stamps (ie: the Time stamps can be around 15 or 20 or ?? second - on average a part - I need to know what the actual average interval is of all the entries).
2) In Hours how long did this process run (ie: Last Time Stamp minus the First Time Stamp - rounded down to the nearst whole number).
This can be figured with a formula or vba, whatever is easier.
I have included an example of the Time Stamps.
Thanks...
Jim
The Time Stamps start in cell A4 and can have varying number of entries in column A.
I need to determine 2 things:
1) What is the average difference for all the Time Stamps. I'm trying to detemine what the average time in seconds is between all the Time Stamps (ie: the Time stamps can be around 15 or 20 or ?? second - on average a part - I need to know what the actual average interval is of all the entries).
2) In Hours how long did this process run (ie: Last Time Stamp minus the First Time Stamp - rounded down to the nearst whole number).
This can be figured with a formula or vba, whatever is easier.
I have included an example of the Time Stamps.
Thanks...
Jim