title: Excel Question: I need a date and time formula to convert between time zones
body: <p>I am trying to find a way to calculate a duration in days between my, time zone (Central), and (Pacific; Mountain; Eastern). Just do not know where to start. My criteria would be as follows: </p>
  
  <p>Cell C5:C100 would be the timestamps in this format:3/18/2010 23:45 but for different dates and times. 
  Cell D5:D100 would be the corresponding timezone in text form: Pacific; Mountain; Eastern; Central.</p>
  
  <p>Cell F5 would be where the duration in days would need to be. </p>
  
  <p>Just not sure how to write the formula to give me what I am looking for. I appreciate any assistance in advance. Thanks</p>