Forum Discussion
Solved
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...
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.
Do you know aabout "data validation"? Use that and select "time" as the type of data.
mathetes Thats worked perfectly! Thank you!