Forum Discussion
stephanieporter
Jun 30, 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...
- Jun 30, 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
Jun 30, 2020Gold 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
Jun 30, 2020Copper Contributor