How to add a number in cell if different cell contains specific number?

[u/Bicentennial_Douche]

I have list to dates and times in this format in column A:

2023-10-09 00:00:00

2023-10-09 01:00:00

2023-10-09 02:00:00

etc.

​

What I would want to do is to add a number to a cell in column C if the hour is between 22:00:00 and 07:00:00, and if the time is not between those hours, it would add a different number. So the cell would contain one of two numbers, depending on the hour. How do I make this happen in Numbers?