Help with simple formula

[Richard]

If A1 = Total Items, and 1 hour = 20 (for 100%), and B2
would be the results (total hours/min.)

 

[Frank Kabel]

Hi
do you mean
=A1/20
???

 

[Richard]

Yes, but if your answer is 1.8, how many minutes is the 8

 

[Frank Kabel]

Hi
you could use:
=(A1/20)/24
and format this in the format
hh:mm