Asking the excel formula
for example, when I put 0700 in one column and the last number is "00", the second column want to be 1530, if the first column is 0800, the second column would be 1630, but if the first column I put the number is 0730, means the last 2 number is "30", I want the second column is showed 1600, if 0830 in the first column, the second would be 1700.
How can I set this Formula?
One more question, if I put some chinese in the column, the second column will be showed a standard number like 30, but if i the first column is put "off" or "off XXX", means when there is "off" this text is shown in the first column, there is nothing in the second column, is it worked to make a formula?
Thank you so much! Hope you can help.!