Hi Karl,

You can put a $ sign in front of column and/or row references to lock them when you copy/paste/fill.
E$1 would lock the 1 (for when you fill down a column)
$E1 would lock the E (for when you fill across a row)
$E$1 locks both.
E1 locks neither.

Accounting for the date roll should just be a case of adding the date, time and time adjustment together. If you have any trouble then feel free to attach the workbook to the thread.