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 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago