Hello,
I am working on a project with waterfowl migration and want to find if each location is a "daytime" or "nighttime" location. You can see below what my spreadsheet looks like, I want to determine if the "studytimestamp(GST)" time is between the sunrise or sunset times. The formula that I have entered is =IF(G2>J2&G2<K2,"1","0") yet I am still getting a value of 0 when the time is clearly between sunrise and sunset. Any help on this would be greatly appreciated!
G1 H1 I1 J1 K1 L1
studytimestamp(GST) TimeZone DST sunrise sunset day(1)night(0)
15:15:14 0 0 11:47:46 23:14:45 0
16:33:35 0 0 11:47:56 23:14:59 0
01:52:41 0 0 06:08:51 18:15:22 0
03:36:58 0 0 11:58:08 23:29:25 0
04:48:14 0 0 06:08:51 18:15:22 0
05:16:26 0 0 11:47:14 23:19:01 0
06:26:27 0 0 11:46:43 23:18:32 0
Bookmarks