Multiplying time formats

[Bill Uyer]

I have a column in the time format of h:mm:ss and would like to multiply
that by a number for billing. Is there an easy to do this or do I have to
convert the time to a decimal number and then multiply. Thanks.

 

[Frank Kabel]

Hi
multiply the time value with 24 (if your billing is based on hours).
e.g.
=A1*24*[rate_per_hour]
and format this resulting cell as 'Number'