Forum Discussion
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 ...
Hi David
=SUMPRODUCT((B1:B100-A1:A100)*1)*24
Sergei--
I hope this goes to you. I'm trying to average some time intervals calculated from subtracting an earlier time from a later time. They are MM:SS, like for instance 11:32.
Thanks,
John
Hi John,
That is separate topic, better if you start new conversation with it. In general AVERAGE() shall work.
