Run Pace formula error

Hi all,

I found this runner's log that I really like online yesterday, but the Pace calculator has some issues that a few of my co-workers and I can't figure out. Normally, a pace calculation would be simple: pace = distance / time. However, because this particular spreadsheet takes info from various columns and uses them in some embedded graphs (that I would like to keep functional), the formula is way more complex than my very limited Excel knowledge is able to comprehend. Also, the pace calculation is currently listed as a decimal (7.5 minutes / mile) as opposed to time format (7:30 minutes / mile) and I have no idea how to convert it.

If someone could take a look and help me address these two issues, it would be HUGELY appreciated!

Thank you.