yogi_Compute Sum Of Hours In Column B (BeginningTime and EndingTime Separated by '-')

Google Spreadsheet   Post  #2089

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-30-2016

question by: Meg/Ralph:

https://productforums.google.com/forum/#!topic/docs/Ce5zTEX0f8g;context-place=forum/docs
Converting Time

Hi all, I was wondering if there's a formula in Google Sheets that lets me take range of time (for example: 2-4p) and automatically convert that time to express that the project took 2 hours long? Please let me know if that's doable. I also have a sample sheet if that's helpful in anyway? Thank you in advance.