I have a sheet in this sheet I need a formula I used the below-mentioned formula but gives me always the first condition.
Currently used Below mentioned Formula.
Date | Time | Shift |
7/11/2023 13:20 | 13 | day |
7/11/2023 1:20 | 01 | day |
7/11/2023 2:20 | 02 | day |
Currently used Below mentioned Formula.
Date | Time | Shift |
7/11/2023 13:20 | 13 | =IF(HOUR(AD3)<=10,"day","night") |