View Single Post
  #1   Report Post  
Steve
 
Posts: n/a
Default Separating data ( 1 time range) in one column

I have the following cell:
0800-1000

I need to ref 0800 in one column & 1000 in another, to ultimately subtract
0800 from 1000 to get 2 hours.

What function would do that ?

Thanks,

Steve