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

[Guest]

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

 

[Nick Hodge]

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
(e-mail address removed)