Body Shop Calculations

[Guest]

Our industry bills parts of an hour, ie .1 = 6 minutes or .5 = 30 minutes.
Trying to calc things like 25 X .1 = 2:30 or 2 hours 30 minutes

A1=25, B1=.1, C1=?

What should the formula in C1 be & should the cell be formatted somehow ?

 

[Bob Phillips]

=A1*B1/24

and form at as [h]:mm

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)