How would I calculate a ratio based on specific criteria?

I am trying to automate the calculation of time required to create training, based on industry averages. For example, it should take approximately 49 hours to write/design 1 hour of basic (Level 1)...