I have a spreadsheet that has an event
start time in column A and the
end time in column B.
I have it set it up so when the start time is filled in, the end time is automatically populated with the start time + two hours.
This formula is in each cell:
Code:
=IF(A1 <> "", A1 + TIME(2,0,0), "")
So the user set the start time as
5:30 PM and the end time is automatically
7:30 PM.
I also want the user to be able to set a
custom end time. But if the user does, they have to erase the formula so it won't be there for the next semester of events.
I'm not sure if there is some form of data validation I can do? I could do brute-force dependent drop-down lists, setting one for every 5-minute interval, haha.