How to categorize time into Day/Night?

[waqas17]

Hi All

How can I categorize time as Day or Night?
For example, I have accidents data with the time of occurring of the accident.
If I set that 7:00 PM - 6:00 AM as NIGHT and 6:01 AM - 6:59 PM as DAY, then how can I categorize that the accident occurred during day or night.

The sample of data is as such:
Accident Time Day/Night
0:00 Night
0:35
0:50
0:14
0:02


0:30
1:52
1:28
1:01
1:50
1:30
1:25
1:20
1:39
2:20
2:30
2:17
2:30

I have a large set of data (about 800 entries). Please help me with the formula to use to organize the data.

Thanking you in anticipation.

Waqas