| Book1 | ||||
|---|---|---|---|---|
| A | B | |||
| 2 | 11/1/21 1:00 | 10/31/21 1:00 | ||
| 3 | 11/2/21 2:00 | 11/1/21 2:00 | ||
| 4 | 11/3/21 3:00 | 11/2/21 3:00 | ||
| 5 | 11/4/21 4:00 | 11/3/21 4:00 | ||
| 6 | 11/5/21 5:00 | 11/4/21 5:00 | ||
| 7 | 11/6/21 6:00 | 11/5/21 6:00 | ||
| 8 | 11/7/21 7:00 | 11/6/21 7:00 | ||
| 9 | 11/8/21 8:00 | 11/8/21 8:00 | ||
| 10 | 11/9/21 9:00 | 11/9/21 9:00 | ||
| 11 | 11/10/21 10:00 | 11/10/21 10:00 | ||
| 12 | 11/11/21 11:00 | 11/11/21 11:00 | ||
| 13 | 11/12/21 12:00 | 11/12/21 12:00 | ||
| 14 | 11/13/21 13:00 | 11/13/21 13:00 | ||
| 15 | 11/14/21 14:00 | 11/14/21 14:00 | ||
| 16 | 11/15/21 15:00 | 11/15/21 15:00 | ||
| 17 | 11/16/21 16:00 | 11/16/21 16:00 | ||
| 18 | 11/17/21 17:00 | 11/17/21 17:00 | ||
| 19 | 11/18/21 18:00 | 11/18/21 18:00 | ||
| 20 | 11/19/21 19:00 | 11/19/21 19:00 | ||
| 21 | 11/20/21 20:00 | 11/20/21 20:00 | ||
| 22 | 11/21/21 21:00 | 11/21/21 21:00 | ||
| 23 | 11/22/21 22:00 | 11/22/21 22:00 | ||
| 24 | 11/23/21 23:00 | 11/23/21 23:00 | ||
Sheet1 | ||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| B2:B24 | B2 | =IF(TIME(HOUR(A2),MINUTE(A2),SECOND(A2))<=TIMEVALUE("07:00"),A2-1,A2) |
