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
5 years 42 weeks ago
6 years 28 weeks ago
6 years 40 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 49 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago