I have two columns. In one column, I want to put a time in the first cell below a Column Name (Actual Time).....so 8:00am. Then the column next to it, I want to be able to put a time AMOUNT in (such as .30 for 30 minutes or .90 for 90 minutes ..... and so on. As I put in the time, I need a macro that sees the additional add of time and produces a new time based on the add. So in my example above, if I start with 8:00am in col. F6 and in column g6 out in .30, the new time in col. F7 will be 8:30am.
Hopefully this is not too much of a challenge.
Thank you in advance,