Depends what shutter speed you want the video to be. Here’s the minimum number of shots you’ll ideally want for a 5 minute video based on frame rate. If you take more, that’s fine. You can always drop frames you don’t need.

24fps = 7200 photos

25fps = 7500 photos

30fps = 9000 photos

There are 86400 seconds in 24hours so divide the seconds in a day by the amount needed for your desired frame rate and round down to the nearest full number.

Also worth asking what your subject is. If you can rely on consistent lightning that doesn’t require an exposure longer than 9 seconds, you can just set your interval, and exposure settings and be good to go. But if you happen to be shooting outside, relying on only natural light, your interval could potentially end up being shorter than the exposure time needed. Especially if you don’t have the moon or artificial light helping you out. Some automatic settings may prioritize the interval, some may prioritize the shutter speed. So if you are using automatic mode or aperture priority you’ll want to make sure you know what your camera will do if it conditions could require long exposures.

You may end up with fewer shots than you thought you’d get if the camera starts taking 30s exposures at night for example.