Forum Discussion

stephanieporter's avatar
stephanieporter
Copper Contributor
Jul 01, 2020
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...
  • mathetes's avatar
    Jul 01, 2020

    stephanieporter 

     

    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.

Resources