Spreadsheet: 330797d1404853801-combining-a-if-function-and-lookup-function-irtest
Sheet: anabat

Ready for pivot
Species | Location1 | Download | Date | Night | Time | Hour | Day & Time | Night & Time | Sunset Night | ±Sunset | ±Sunrise | Night length | Sunset | Date+1 | Sunrise | video | Video time start time | time on Video
Noise | L07 | D242 | 2014-05-14 00:00:00 | 2014-05-14 00:00:00 | 13:02:15 | 13:00:00 | 2014-05-14 13:02:15 | 2014-05-14 13:02:15 | 2014-05-14 20:58:33 | 1903-12-31 16:03:42 | 1903-12-31 07:55:32 | 08:08:10 | 20:58:33 | 2014-05-15 00:00:00 | 05:06:43
Noise | L07 | D242 | 2014-05-14 00:00:00 | 2014-05-14 00:00:00 | 20:31:50 | 20:00:00 | 2014-05-14 20:31:50 | 2014-05-14 20:31:50 | 2014-05-14 20:58:33 | 1903-12-31 23:33:17 | 1903-12-31 15:25:07 | 08:08:10 | 20:58:33 | 2014-05-15 00:00:00 | 05:06:43 | 0
Noise | L07 | D242 | 2014-05-14 00:00:00 | 2014-05-14 00:00:00 | 21:39:49 | 21:00:00 | 2014-05-14 21:39:49 | 2014-05-14 21:39:49 | 2014-05-14 20:58:33 | 00:41:16 | 1903-12-31 16:33:06 | 08:08:10 | 20:58:33 | 2014-05-15 00:00:00 | 05:06:43 | 0
Noise | L07 | D242 | 2014-05-14 00:00:00 | 2014-05-14 00:00:00 | 21:53:19 | 21:00:00 | 2014-05-14 21:53:19 | 2014-05-14 21:53:19 | 2014-05-14 20:58:33 | 00:54:46 | 1903-12-31 16:46:36 | 08:08:10 | 20:58:33 | 2014-05-15 00:00:00 | 05:06:43 | 0
Pip.pip | L07 | D242 | 2014-05-14 00:00:00 | 2014-05-14 00:00:00 | 21:32:10 | 21:00:00 | 2014-05-14 21:32:10 | 2014-05-14 21:32:10 | 2014-05-14 20:58:33 | 00:33:37 | 1903-12-31 16:25:27 | 08:08:10 | 20:58:33 | 2014-05-15 00:00:00 | 05:06:43 | 0 | #N/A | #N/A
Pip.pip | L07 | D242 | 2014-05-14 00:00:00 | 2014-05-14 00:00:00 | 21:32:43 | 21:00:00 | 2014-05-14 21:32:43 | 2014-05-14 21:32:43 | 2014-05-14 20:58:33 | 00:34:10 | 1903-12-31 16:26:00 | 08:08:10 | 20:58:33 | 2014-05-15 00:00:00 | 05:06:43 | 0 | #N/A | #N/A
Pip.pip | L07 | D242 | 2014-05-14 00:00:00 | 2014-05-14 00:00:00 | 21:34:28 | 21:00:00 | 2014-05-14 21:34:28 | 2014-05-14 21:34:28 | 2014-05-14 20:58:33 | 00:35:55 | 1903-12-31 16:27:45 | 08:08:10 | 20:58:33 | 2014-05-15 00:00:00 | 05:06:43 | 0 | #N/A | #N/A
Pip.pip | L07 | D242 | 2014-05-14 00:00:00 | 2014-05-14 00:00:00 | 21:34:52 | 21:00:00 | 2014-05-14 21:34:52 | 2014-05-14 21:34:52 | 2014-05-14 20:58:33 | 00:36:19 | 1903-12-31 16:28:09 | 08:08:10 | 20:58:33 | 2014-05-15 00:00:00 | 05:06:43 | 0 | #N/A | #N/A
Un-ID | L07 | D242 | 2014-05-14 00:00:00 | 2014-05-14 00:00:00 | 21:35:06 | 21:00:00 | 2014-05-14 21:35:06 | 2014-05-14 21:35:06 | 2014-05-14 20:58:33 | 00:36:33 | 1903-12-31 16:28:23 | 08:08:10 | 20:58:33 | 2014-05-15 00:00:00 | 05:06:43 | 0 | #N/A | #N/A
Pip.pip | L07 | D242 | 2014-05-14 00:00:00 | 2014-05-14 00:00:00 | 21:37:07 | 21:00:00 | 2014-05-14 21:37:07 | 2014-05-14 21:37:07 | 2014-05-14 20:58:33 | 00:38:34 | 1903-12-31 16:30:24 | 08:08:10 | 20:58:33 | 2014-05-15 00:00:00 | 05:06:43 | 0 | #N/A | #N/A
Pip.pip | L07 | D242 | 2014-05-14 00:00:00 | 2014-05-14 00:00:00 | 21:38:39 | 21:00:00 | 2014-05-14 21:38:39 | 2014-05-14 21:38:39 | 2014-05-14 20:58:33 | 00:40:06 | 1903-12-31 16:31:56 | 08:08:10 | 20:58:33 | 2014-05-15 00:00:00 | 05:06:43 | 0 | #N/A | #N/A
Pip.pip | L07 | D242 | 2014-05-14 00:00:00 | 2014-05-14 00:00:00 | 21:39:24 | 21:00:00 | 2014-05-14 21:39:24 | 2014-05-14 21:39:24 | 2014-05-14 20:58:33 | 00:40:51 | 1903-12-31 16:32:41 | 08:08:10 | 20:58:33 | 2014-05-15 00:00:00 | 05:06:43 | 0 | #N/A | #N/A
Pip.pip | L07 | D242 | 2014-05-14 00:00:00 | 2014-05-14 00:00:00 | 21:39:42 | 21:00:00 | 2014-05-14 21:39:42 | 2014-05-14 21:39:42 | 2014-05-14 20:58:33 | 00:41:09 | 1903-12-31 16:32:59 | 08:08:10 | 20:58:33 | 2014-05-15 00:00:00 | 05:06:43 | 0 | #N/A | #N/A
Pip.pip | L07 | D242 | 2014-05-14 00:00:00 | 2014-05-14 00:00:00 | 21:40:57 | 21:00:00 | 2014-05-14 21:40:57 | 2014-05-14 21:40:57 | 2014-05-14 20:58:33 | 00:42:24 | 1903-12-31 16:34:14 | 08:08:10 | 20:58:33 | 2014-05-15 00:00:00 | 05:06:43 | 0 | #N/A | #N/A
Pip.pip | L07 | D242 | 2014-05-14 00:00:00 | 2014-05-14 00:00:00 | 21:41:52 | 21:00:00 | 2014-05-14 21:41:52 | 2014-05-14 21:41:52 | 2014-05-14 20:58:33 | 00:43:19 | 1903-12-31 16:35:09 | 08:08:10 | 20:58:33 | 2014-05-15 00:00:00 | 05:06:43 | 0 | #N/A | #N/A
Un-ID | L07 | D242 | 2014-05-14 00:00:00 | 2014-05-14 00:00:00 | 21:44:43 | 21:00:00 | 2014-05-14 21:44:43 | 2014-05-14 21:44:43 | 2014-05-14 20:58:33 | 00:46:10 | 1903-12-31 16:38:00 | 08:08:10 | 20:58:33 | 2014-05-15 00:00:00 | 05:06:43 | 0 | #N/A | #N/A
Pip.pip | L07 | D242 | 2014-05-14 00:00:00 | 2014-05-14 00:00:00 | 21:45:02 | 21:00:00 | 2014-05-14 21:45:02 | 2014-05-14 21:45:02 | 2014-05-14 20:58:33 | 00:46:29 | 1903-12-31 16:38:19 | 08:08:10 | 20:58:33 | 2014-05-15 00:00:00 | 05:06:43 | 0 | #N/A | #N/A
Pip.p-py | L07 | D242 | 2014-05-14 00:00:00 | 2014-05-14 00:00:00 | 21:45:39 | 21:00:00 | 2014-05-14 21:45:39 | 2014-05-14 21:45:39 | 2014-05-14 20:58:33 | 00:47:06 | 1903-12-31 16:38:56 | 08:08:10 | 20:58:33 | 2014-05-15 00:00:00 | 05:06:43 | 0 | #N/A | #N/A
Pip.pip | L07 | D242 | 2014-05-14 00:00:00 | 2014-05-14 00:00:00 | 21:52:07 | 21:00:00 | 2014-05-14 21:52:07 | 2014-05-14 21:52:07 | 2014-05-14 20:58:33 | 00:53:34 | 1903-12-31 16:45:24 | 08:08:10 | 20:58:33 | 2014-05-15 00:00:00 | 05:06:43 | 0 | #N/A | #N/A
Pip.pip | L07 | D242 | 2014-05-14 00:00:00 | 2014-05-14 00:00:00 | 21:53:42 | 21:00:00 | 2014-05-14 21:53:42 | 2014-05-14 21:53:42 | 2014-05-14 20:58:33 | 00:55:09 | 1903-12-31 16:46:59 | 08:08:10 | 20:58:33 | 2014-05-15 00:00:00 | 05:06:43 | 0 | #N/A | #N/A
Pip.pip | L07 | D242 | 2014-05-14 00:00:00 | 2014-05-14 00:00:00 | 21:57:37 | 21:00:00 | 2014-05-14 21:57:37 | 2014-05-14 21:57:37 | 2014-05-14 20:58:33 | 00:59:04 | 1903-12-31 16:50:54 | 08:08:10 | 20:58:33 | 2014-05-15 00:00:00 | 05:06:43 | 0 | #N/A | #N/A
Pip.pip | L07 | D242 | 2014-05-14 00:00:00 | 2014-05-14 00:00:00 | 21:58:39 | 21:00:00 | 2014-05-14 21:58:39 | 2014-05-14 21:58:39 | 2014-05-14 20:58:33 | 01:00:06 | 1903-12-31 16:51:56 | 08:08:10 | 20:58:33 | 2014-05-15 00:00:00 | 05:06:43 | 0 | #N/A | #N/A
Pip.pip | L08 | D246 | 2014-06-04 00:00:00 | 2014-06-04 00:00:00 | 21:46:21 | 21:00:00 | 2014-06-04 21:46:21 | 2014-06-04 21:46:21 | 2014-06-04 21:28:18 | 00:18:03 | 1903-12-31 17:04:58 | 07:13:05 | 21:28:18 | 2014-06-05 00:00:00 | 04:41:23 | 0 | #N/A | #N/A
Pip.pip | L08 | D246 | 2014-06-04 00:00:00 | 2014-06-04 00:00:00 | 21:46:29 | 21:00:00 | 2014-06-04 21:46:29 | 2014-06-04 21:46:29 | 2014-06-04 21:28:18 | 00:18:11 | 1903-12-31 17:05:06 | 07:13:05 | 21:28:18 | 2014-06-05 00:00:00 | 04:41:23 | 0 | #N/A | #N/A