Seems to me if it is bacterial it would be less than 8 hours.
If you go to bed after eating something at dinner that is going to make you sick, do you wake up about midnight or one in the morning knowing it is time to run to the porcelain facility and hoping beyond hope that it isn’t both ends at once. Sorry for the graphics.