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'
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula problem with decimal 2
Multiplying times 11
How do I multiply ALL CELL in spreadsheet at once by .5 ? 4
format a cell when I type 10 it will multiply 10 by .585 3
Calculation of weighed average 6
sumif and translate annual hours into weekly quarter hours 21
Purchase Order Form 2
convert [h]:mm:ss to real number that I can use as a multiplier 3

Back
Top