Forum Discussion
David Ramseur
Oct 31, 2017Copper Contributor
Need help with formula for average time between two diferent sets of dates.
I am trying to calculate average time between two different date columns. I have been typing the following formula out for over 20 different rows: =((b1-a1)*24+(b2-a2)*24+(b3-a3)*24...). How can I ...
SergeiBaklan
Oct 31, 2017Diamond Contributor
Hi David
=SUMPRODUCT((B1:B100-A1:A100)*1)*24