Photos not sorting in chronological order on Mac
I'm adding all of our old vacation photos into the Mac's Photos app. I'm on a M1 MacBook Pro running Sonoma 14.7.2 and using Photos 9.0. Both my wife and I took pictures on separate cameras (her iPhone and my Sanyo camera/camcorder) and each camera has been verified to have the correct date and time. I've been scratching my head for ages trying to figure out why the merged photos aren't sorting chronologically. I think I've discovered what's happening. There are clusters of photos imported from one device and within that cluster the pictures are chronologically ordered. Then there is another cluster from the other device and within that cluster they too are chronologically ordered. However, that all means that the flow of the combined imported pictures keeps jumping back and forth in time, between the clusters. How can I sort these pictures so that the merged set is fully chronologically ordered?
In the View → Sort menu there are no options to choose from. There is just the one, grayed out option that says "Keep Sorted by Oldest Capture Date".
MacBook Pro (M1, 2020)