View Single Post
  #2   Report Post  
Nick Hodge
 
Posts: n/a
Default

Blusty

In C1 enter

=A1*B1

format as [hh]:mm:ss (the brackets will stop the hours over 24 incrementing
to days)

Then in D1 enter =(C1*24)*100

formatted as currency

You may wish to check out

http://www.cpearson.com/excel/datetime.htm


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Blusty" wrote in message
...


I have a column that is the time it takes to do a task.(hh:mm:ss). I have
a
column that is the number of tasks per month. I have a column that should
be
the result of the first and second column. This will sometimes be only
seconds a task or minutes a task. Then I need a fourth column that would
be
the total money this montly task would take if 1 hour would cost #100.00.
You
can tell I am not an accounting person. I can find no way to solve this.
Help