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   Feb-07-2016
post by: PAUL KOCH II :!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

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