Hello all;
I'm hoping someone can help me with this dilemma. I have a drop down cell that triggers another cell to track the start times of work. I've figured out how to make everything work without the reoccurring "now" time stamp. My problem is i would like to add another if command, below is the formula that's currently working with the drop down that says "started" and "Time Adjust". My objective, is when someone clicks "started" the now command issues the current date and time in another cell. What I need is to also have them be able to select "Time Adj." and they can manually enter a time from another cell.
=IF(Q8="Started",IF(W8="",NOW(),W8),"")
what I thought would work is this:
=IF(Q8="Started",IF(W8="",NOW(),W8),AH8) this formula would not have the "Time Adj." drop down selection. Instead it would just copy the cell information in AH8.
OR
=IF(Q8="Started",IF(W8="",NOW(),W8),""),IF(Q8="Time Adj.",AH8,"")
OR
=IF(AND(Q8="Started",AH8=""),NOW(),""),IF(Q8="Time Adj.",AH8,"")
to Explain, cell Q8 has a drop down, cell W8 is where I want the time, cell AH8 is where you would manually add the time time if selecting "Time Adj." in the drop down of cell Q8.
Thanks in advance
I'm hoping someone can help me with this dilemma. I have a drop down cell that triggers another cell to track the start times of work. I've figured out how to make everything work without the reoccurring "now" time stamp. My problem is i would like to add another if command, below is the formula that's currently working with the drop down that says "started" and "Time Adjust". My objective, is when someone clicks "started" the now command issues the current date and time in another cell. What I need is to also have them be able to select "Time Adj." and they can manually enter a time from another cell.
=IF(Q8="Started",IF(W8="",NOW(),W8),"")
what I thought would work is this:
=IF(Q8="Started",IF(W8="",NOW(),W8),AH8) this formula would not have the "Time Adj." drop down selection. Instead it would just copy the cell information in AH8.
OR
=IF(Q8="Started",IF(W8="",NOW(),W8),""),IF(Q8="Time Adj.",AH8,"")
OR
=IF(AND(Q8="Started",AH8=""),NOW(),""),IF(Q8="Time Adj.",AH8,"")
to Explain, cell Q8 has a drop down, cell W8 is where I want the time, cell AH8 is where you would manually add the time time if selecting "Time Adj." in the drop down of cell Q8.
Thanks in advance