Sunday, November 24, 2013

yogi_Compute Appointment Date And Time In Appointment Location Time Zone Given Start Time And Date In EST Zone

                                          Google Spreadsheet   Post  #1432
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Nov 24, 2013
question by dslon1971 (!mydiscussions/docs/lht9d1smQ_k)
Transit time for shipments
I am wanting to build a way to track shipments / truckloads for my company through a simple interface based on bill time and transit time to person recieving.  Is this best accomplished through sheets or a Google script?  I need to factor in a receiving window a the person receiving the shipment also based on the time.  

Thanks in advance for all of your help.

Donny Sloan

I am trying to calculate the transit time from shipments from Dalton, Georgia to other plants based on ETA times.  On the first sheet in cell A3, the bill time and date is added.  In cell B3, the user selects the destination which contents are populated from a list on the second tab of the worksheet named "Data".  Cell # C3 does a VLOOKUP based on the destination in the data sheet and returns the time.  Cell # D3 performs the sum function and adds the times together.  I need to somehow calculate in where it returns the time for the timezone the destination is at and not EST as it is currently doing.  Please let me know if you need further information.