Spreadsheet: 92590d1292155998-need-if-then-formula-that-changes-with-time-artiststevens_ifthen-1-
Sheet: Sheet3

Date | Time | [NAME]
2010-01-04 00:00:00 | 1900-01-01 00:00:00 | 1.4427
2010-01-04 00:00:00 | 01:00:00 | 1.4427
2010-01-04 00:00:00 | 02:00:00 | 1.4427
2010-01-04 00:00:00 | 03:00:00 | 1.4427
2010-01-04 00:00:00 | 04:00:00 | 1.4427
2010-01-04 00:00:00 | 05:00:00 | 1.4427
2010-01-04 00:00:00 | 06:00:00 | 1.4427
2010-01-04 00:00:00 | 07:00:00 | 1.4427
2010-01-04 00:00:00 | 08:00:00 | 1.4427
2010-01-04 00:00:00 | 09:00:00 | 1.4427
2010-01-04 00:00:00 | 10:00:00 | 1.4427
2010-01-04 00:00:00 | 11:00:00 | 1.4427
2010-01-04 00:00:00 | 12:00:00 | 1.4427
2010-01-04 00:00:00 | 13:00:00 | 1.4427
2010-01-04 00:00:00 | 14:00:00 | 1.4427
2010-01-04 00:00:00 | 15:00:00 | 1.4427
2010-01-04 00:00:00 | 16:00:00 | 1.4427
2010-01-04 00:00:00 | 17:00:00 | 1.4427
2010-01-04 00:00:00 | 18:00:00 | 1.4427
2010-01-04 00:00:00 | 19:00:00 | 1.4427
2010-01-04 00:00:00 | 20:00:00 | 1.4427
2010-01-04 00:00:00 | 21:00:00 | 1.4427
2010-01-04 00:00:00 | 22:00:00 | 1.4427
2010-01-04 00:00:00 | 23:00:00 | 1.4427
2010-01-05 00:00:00 | 1900-01-01 00:00:00 | 1.4357
2010-01-05 00:00:00 | 01:00:00 | 1.4357
2010-01-05 00:00:00 | 02:00:00 | 1.4357
2010-01-05 00:00:00 | 03:00:00 | 1.4357
2010-01-05 00:00:00 | 04:00:00 | 1.4357
2010-01-05 00:00:00 | 05:00:00 | 1.4357
2010-01-05 00:00:00 | 06:00:00 | 1.4357
2010-01-05 00:00:00 | 07:00:00 | 1.4357
2010-01-05 00:00:00 | 08:00:00 | 1.4357
2010-01-05 00:00:00 | 09:00:00 | 1.4357
2010-01-05 00:00:00 | 10:00:00 | 1.4357
2010-01-05 00:00:00 | 11:00:00 | 1.4357
2010-01-05 00:00:00 | 12:00:00 | 1.4357
2010-01-05 00:00:00 | 13:00:00 | 1.4357
2010-01-05 00:00:00 | 14:00:00 | 1.4357
2010-01-05 00:00:00 | 15:00:00 | 1.4357
2010-01-05 00:00:00 | 16:00:00 | 1.4357
2010-01-05 00:00:00 | 17:00:00 | 1.4357
2010-01-05 00:00:00 | 18:00:00 | 1.4357
2010-01-05 00:00:00 | 19:00:00 | 1.4357
2010-01-05 00:00:00 | 20:00:00 | 1.4357
2010-01-05 00:00:00 | 21:00:00 | 1.4357
2010-01-05 00:00:00 | 22:00:00 | 1.4357
2010-01-05 00:00:00 | 23:00:00 | 1.4357
2010-01-06 00:00:00 | 1900-01-01 00:00:00 | 1.4402
2010-01-06 00:00:00 | 01:00:00 | 1.4402
2010-01-06 00:00:00 | 02:00:00 | 1.4402
2010-01-06 00:00:00 | 03:00:00 | 1.4402
2010-01-06 00:00:00 | 04:00:00 | 1.4402
2010-01-06 00:00:00 | 05:00:00 | 1.4402
2010-01-06 00:00:00 | 06:00:00 | 1.4402
2010-01-06 00:00:00 | 07:00:00 | 1.4402
2010-01-06 00:00:00 | 08:00:00 | 1.4402
2010-01-06 00:00:00 | 09:00:00 | 1.4402
2010-01-06 00:00:00 | 10:00:00 | 1.4402
2010-01-06 00:00:00 | 11:00:00 | 1.4402
2010-01-06 00:00:00 | 12:00:00 | 1.4402
2010-01-06 00:00:00 | 13:00:00 | 1.4402
2010-01-06 00:00:00 | 14:00:00 | 1.4402
2010-01-06 00:00:00 | 15:00:00 | 1.4402
2010-01-06 00:00:00 | 16:00:00 | 1.4402
2010-01-06 00:00:00 | 17:00:00 | 1.4402
2010-01-06 00:00:00 | 18:00:00 | 1.4402
2010-01-06 00:00:00 | 19:00:00 | 1.4402
2010-01-06 00:00:00 | 20:00:00 | 1.4402
2010-01-06 00:00:00 | 21:00:00 | 1.4402
2010-01-06 00:00:00 | 22:00:00 | 1.4402
2010-01-06 00:00:00 | 23:00:00 | 1.4402
2010-01-07 00:00:00 | 1900-01-01 00:00:00 | 1.4315
2010-01-07 00:00:00 | 01:00:00 | 1.4315
2010-01-07 00:00:00 | 02:00:00 | 1.4315
2010-01-07 00:00:00 | 03:00:00 | 1.4315
2010-01-07 00:00:00 | 04:00:00 | 1.4315
2010-01-07 00:00:00 | 05:00:00 | 1.4315
2010-01-07 00:00:00 | 06:00:00 | 1.4315
2010-01-07 00:00:00 | 07:00:00 | 1.4315
2010-01-07 00:00:00 | 08:00:00 | 1.4315
2010-01-07 00:00:00 | 09:00:00 | 1.4315
2010-01-07 00:00:00 | 10:00:00 | 1.4315
2010-01-07 00:00:00 | 11:00:00 | 1.4315
2010-01-07 00:00:00 | 12:00:00 | 1.4315
2010-01-07 00:00:00 | 13:00:00 | 1.4315
2010-01-07 00:00:00 | 14:00:00 | 1.4315
2010-01-07 00:00:00 | 15:00:00 | 1.4315
2010-01-07 00:00:00 | 16:00:00 | 1.4315
2010-01-07 00:00:00 | 17:00:00 | 1.4315
2010-01-07 00:00:00 | 18:00:00 | 1.4315
2010-01-07 00:00:00 | 19:00:00 | 1.4315
2010-01-07 00:00:00 | 20:00:00 | 1.4315
2010-01-07 00:00:00 | 21:00:00 | 1.4315
2010-01-07 00:00:00 | 22:00:00 | 1.4315
2010-01-07 00:00:00 | 23:00:00 | 1.4315
2010-01-08 00:00:00 | 1900-01-01 00:00:00 | #N/A