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   Jun-30-2017
question by Jikuu:!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


So first split on "-" to get the two times

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.