Sunday, February 7, 2016

yogi_Compute Time Duration A Person Signed Up For Given Data In HHMM-HHMM In The Same Day Or Spanning Overnight

Google Spreadsheet   Post  #2031
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-07-2016
post by: PAUL KOCH II :
https://productforums.google.com/forum/#!topic/docs/1nhiDcuvf4g;context-place=forum/docs
Getting the total hours from 2 times in the same cell
I have a spreadsheet that looks like this
RE/SQD DrHaggerty1500-1900
RE/SQD DrMark1500-1900
RE/SQD DrStefan1500-1900
EMTRich W1500-2000
EMT/Drscott1530-2200
FF/EMTCarlos1500-1900

I want to take those times and figure out the total time they signed up for automatically. Can anyone help?
---------------------------------------------------------------------------------------------------------