I have a spreadsheet for recording room usage. Column A has StartTime,
Column B has EndTime and Column C has formula EndTime - Startime.
Each day is split into 6 periods.
If I move (cut & paste) a booking from row 2 to row 4, the formula in
C2 adjusts to the new location of the data (even when absolute
reference is used) and the forumula in C4 becomes =#REF-#REF. I can't
cut & paste the whole line of data as Column C is protected and I'd be
unable to re-insert the formula.