Jun 30 2020 06:10 PM
Hi,
I'm needing help with a IFS and time formula.
Column A = Time
Column B = Time zone (so will just be a drop down box list LON, NYC, HK, ANZ)
Column C = Time
So basically, I need a formula that says all of the following
IF Column A = LON then Column C = Column A + 9 hours
IF Column A = NYC then Column C = Column A + 14 hours
IF Column A = HK then Column C = Column A + 2 hours
Both A and C are formatted in time. How do I write this formula for Column B? It doesn't seem to be working with the cell being in time.
Thanks!
Jun 30 2020 06:30 PM
Solution
I'd recommend creating a table for the amounts to be added....as I've done in the attached. The first column also serves as the basis for the drop down list in selecting the city.
The formula is mostly a matter of entering the numbers in "time" format.
Jun 30 2020 09:53 PM
Jun 30 2020 09:53 PM
Ive attached some screenshots
Jul 01 2020 06:48 AM
That's great. It's always better to have fixed it yourself. Makes for a much better learning experience.
Nevertheless, don't hesitate to come back with questions when you get stumped.
Jul 01 2020 06:37 PM
Thanks so much! Do you have any idea how to make column A a time only picker? I already have a column which is a date picker. I want a second date picker for column a but I want it to be time only. I'm not sure how to code for 2 different time pickers in the same project. Doesn't seem to work. @mathetes
Jul 01 2020 06:48 PM
Do you know aabout "data validation"? Use that and select "time" as the type of data.
Jun 30 2020 06:30 PM
Solution
I'd recommend creating a table for the amounts to be added....as I've done in the attached. The first column also serves as the basis for the drop down list in selecting the city.
The formula is mostly a matter of entering the numbers in "time" format.