Body Shop Calculations
 

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 ?

Body Shop Calculations
 

=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)

"Dale" wrote in message
...
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 ?