need column with 00:00:00 like stopwatch x's a number donemonthly
 

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

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