Forum Discussion
IFS Formula and time
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!
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.
9 Replies
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.
Ive attached some screenshots
mathetes FIXED IT!
- Ive just tried it in my spreadsheet and I'm getting errors! I dont know what I'm doing wrong. I just copied your formula but applied it to the relevant cells.
I actually should have a fourth option
ANZ 0:00:00
LON 9:00:00
NYC 14:00:00
HK 2:00:00
I also have the formulas on another tab. Is that why? I selected the tab and the right area I dont know what Ive done wrong.
