Conversion table
I need to have a cell that you can enter a number in between 1-60 and it will convert this number from a conversion table. How do I do this??
Conversion table
01-06 Mins = 0.1HRS
07-12 Mins = 0.2HRS
13-18 Mins = 0.3HRS
19-24 Mins = 0.4HRS
25-30 Mins = 0.5HRS
ECT
For example I have a job that took 14 minutes it would be 0.3hrs

Recent comments
7 years 25 weeks ago
8 years 10 weeks ago
8 years 22 weeks ago
8 years 25 weeks ago
8 years 26 weeks ago
8 years 32 weeks ago
8 years 40 weeks ago
8 years 40 weeks ago
8 years 40 weeks ago
8 years 40 weeks ago