Hello, JP, and welcome to the Grammar Exchange.
I. How many hours in a day?
II. How many hours are in a day?
Which of the above statements is correct?
Sentence (II) is the correct sentence. The question relates to the declarative sentence "[X] hours are in a day," in which you can see that the verb is needed.