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.
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 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.
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.