Friday, June 30, 2017

yogi_Compute Total Time Duration In hh:mm:ss For Set Of Times In Column A

Google Spreadsheet   Post  #2196
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-30-2017
question by Jikuu:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/wdE2XKiGvEA;context-place=forum/docs
Calculating difference and sum on a SPLIT array

I'm trying to calculate the total number of hours between time ranges in multiple cells at the same time

09:00-12:00
12:00-15:00
15:00-18:00
18:00-21:00
21:00-00:00

So first split on "-" to get the two times
=ArrayFormula(SPLIT(A1:A5,"-"))

Then calculate the difference between the two times and finally add them all up for the total number of hours. Not sure how to go about performing functions on all the results in an Array.

-Matt