google docs schedule template different time zones

Look at the gSheet as your read through this so you can follow along. I hope I have made my issue clear enough for you folks to follow, and I am interested in hearing possible solutions! Thank you in advance.

As you can imagine this is a clunky solution. and I’m wondering if there is some button I can insert to make the times in column A convert to another time zone (for example, I can press a button and they all switch to Dallas, I press it again and switch it to Baltimore later.)Īs of now, the only solution I can think of to include all three time zones is to write them out in three separate columns, one for each time zone. Right now I have the time and date listed out half hour by half hour in Tokyo time (since that’s where we start) in column A. it starts with Japan time but then I need it to switch to Dallas time (then later Maryland time). when can I feed her? When can she sleep? Etc.). I basically want it all laid out because I’ll be doing this monster journey alone with my toddler and I want to have a schedule prepared from door to door for her so we both can get through these long haul flights with some kind of guideline to follow (I.e. I am using Google sheets to outline a half hour by half hour schedule of my mega journey across three airports from Akita, Japan to Baltimore, Maryland (and just as many time zones). Hello r/googlesheets community! Forgive me because I am relatively new to sheets (and still somewhat new to spreadsheets). Please be patient, sometimes it takes a couple of minutes. OPs must reply to the best solution with 'Solution Verified' to change the flair to 'Solved' and award the user a ClippyPoint. You can use this Google Form link to request a shared google sheet be emailed to you that you can use to provide a sample of your issue. Providing a sample of data will make it easier for others to help you. Google's Function List Provide your data! Submissions Submission Guide Wiki Resources

Help and support with your functions, formulas, formatting, and Apps Scripts macros in Google Sheets.

Google docs schedule template different time zones