Forum Discussion
stephanieporter
Jul 01, 2020Copper Contributor
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...
- Jul 01, 2020
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.
mathetes
Jul 01, 2020Silver Contributor
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.
stephanieporter
Jul 01, 2020Copper Contributor