While both New York and all of Germany observe Daylight Savings Time, the start and stop dates are different in each location... how did you want to handle that? Also, do you have a cell that tells which location the times are to be considered in? If so, what sheet/cell is that in? By the way, in case it will matter, what city or cities in Germany are you using?