Excel Question: I need a date and time formula to convert between time zones
- by Harold Nottingham
Hello,
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:
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.
Cell F5 would be where the duration in days would need to be.
Just not sure how to write the formula to give me what I am looking for. I appreciate any assistance in advance. Thanks