Multiplying time formats

  • Thread starter Thread starter Bill Uyer
  • Start date Start date
B

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.
 
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'
 
Back
Top