>>>How long ago did the oil that's being used today form<<<?

Basically anywhere from 10 to 150 million years ago. The North Sea for instance has oil that was formed by the compression of vegetable and animal matter that settled and then has had sediment layered on top causing a downward pressure. The oil in the North sea is approximately 30-60 million years old or about the end of the Jurassic period.