Spreading Formulas across the whole document
=SUMPRODUCT((B1:I10<"")*(B1:I10-A1:H10))
adjust to suit, but note how the subtracted ranges are offset by a column
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Vlad" wrote in message
...
I have a document that it has 35 thousand entries of different times. I
need
to figure out the time intervals between every single entry. The formula i
use is pretty simple =(H#-H#). For example how would i adjust that formula
so
it takes in account all the 30 something thousand of other rows.
My thing looks something like this
Time Interval
12:01:03.396 AM
12:01:06.309 AM
12:02:25.823 AM
12:02:30.195 AM
12:03:49.709 AM
Is there a formula that i can get the difference between each time and add
it up for a total amount of hours....
please any advice is VERY appreciate it
Thank You
|