Spreadsheet: 600600d1543865268-fill-in-cell-based-on-relative-position-of-other-cell-relative_fill_cell
Sheet: Sheet1

 | Manually
 | DAY 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAY 2
 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 1900-01-01 00:00:00 | 1900-01-01 01:00:00 | 1900-01-01 02:00:00 | 1900-01-01 03:00:00 | 1900-01-01 04:00:00 | 1900-01-01 05:00:00 | 1900-01-01 06:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 1900-01-01 00:00:00 | 1900-01-01 01:00:00 | 1900-01-01 02:00:00 | 1900-01-01 03:00:00 | 1900-01-01 04:00:00 | 1900-01-01 05:00:00 | 1900-01-01 06:00:00
Dinner |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Wake up | 1 | As seen in Sheet 2, I start waking up 12 hours before I start with dinner |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Breakfast |  | 1 |  |  |  |  |  |  |  |  |  |  | Only interested in when I start doing something relative to dinner, so no absolute time |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Lunch |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Work |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Movie |  |  |  |  |  |  |  | As seen in Sheet 2, I start working 5 hours before I start with dinner |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Snack |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Sleep |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  | `
 | IF function
 | DAY 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAY 2
 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 1900-01-01 00:00:00 | 1900-01-01 01:00:00 | 1900-01-01 02:00:00 | 1900-01-01 03:00:00 | 1900-01-01 04:00:00 | 1900-01-01 05:00:00 | 1900-01-01 06:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 1900-01-01 00:00:00 | 1900-01-01 01:00:00 | 1900-01-01 02:00:00 | 1900-01-01 03:00:00 | 1900-01-01 04:00:00 | 1900-01-01 05:00:00 | 1900-01-01 06:00:00
Dinner |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Wake up
Breakfast
Lunch |  |  |  |  |  |  |  |  |  | Cells donkt know that I start working 5 hours before dinner, so each cell has an IF function
Work
Movie
Snack
Sleep
 | Other way? |  |  | [NAME] is to fill in a cell relative to "dinner", in sheet 2 the values that determine the correct column are displayed
 | DAY 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAY 2
 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 1900-01-01 00:00:00 | 1900-01-01 01:00:00 | 1900-01-01 02:00:00 | 1900-01-01 03:00:00 | 1900-01-01 04:00:00 | 1900-01-01 05:00:00 | 1900-01-01 06:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 1900-01-01 00:00:00 | 1900-01-01 01:00:00 | 1900-01-01 02:00:00 | 1900-01-01 03:00:00 | 1900-01-01 04:00:00 | 1900-01-01 05:00:00 | 1900-01-01 06:00:00
Dinner |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Wake up
Breakfast
Lunch
Work
Movie
Snack
Sleep