What am I doing wrong??

[macamarr]

In a report;
I am trying to calculate speed off minutes and miles traveled. I convert the minutes to hours by dividing minutes by 60. When I put the formula in for the speed it is no where near what is should be.

Example
1104 minutes = 18.4 hrs
miles = 366

366/18.4 = 19.89 Unless I am doing this wrong 19.89 is the speed.

my formula: =([miles]/[plannedTravel Time]) gives me 0.28

my conclusion: diviving the minutes and not hours. So how can I get it to divide by hours?

 

[Dr_Worm]

Try this to get hours,
my formula: =([miles]/[plannedTravel Time]*60)